Calculate Days Of Zero Stock - Inventory Management Insights w/Power BI

[@EnterpriseDNA]

***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download FREE - Power BI Resources - enterprisedna.co/power-bi-resources Enterprise DNA Membership - enterprisedna.co/membership Enterprise DNA Online - portal.enterprisedna.co/ Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/ ***** Related Links ***** Inventory Management Insights with Power BI: Comparing Stock To Sales - blog.enterprisedna.co/advanced-budgeting-insights-in-power-bi-free-training-workshop/ Power BI Mobile Reporting Tips and Techniques - blog.enterprisedna.co/mobile-reporting-tip-techniques-for-power-bi/ The Importance Of Creating Compelling Power BI Visualizations - blog.enterprisedna.co/the-importance-of-creating-compelling-visuals-reports-in-power-bi/ ***** Related Course Modules ***** Dashboarding & Data Visualization Intensive - portal.enterprisedna.co/p/dashboarding-and-data-visualisation-intensive Power BI Resources - portal.enterprisedna.co/p/power-bi-resources Scenario Method Workshops - portal.enterprisedna.co/p/scenario-method-workshops ***** Related Support Forum Posts ***** Inventory Management - forum.enterprisedna.co/t/inventory-managment/829 Inventory Management [Shortage Report] - forum.enterprisedna.co/t/inventory-management-shortage-report/629 Inventory Management Stock Turnover - forum.enterprisedna.co/t/inventory-management-stock-turnover/1075 For more inventory management support queries to review see here - forum.enterprisedna.co/search?q=inventory%20management

[@FullMoonHatch]

You helped me solve a problem Ive been working on for hours. Thank you!

[@EnterpriseDNA]

Hi Life2Liv, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@Soulenergy31]

great job on this visualization Sam!!

[@marcosjosetiburciorodrigue3369]

Thanks GOD I found this videos!

[@NL-tq1yr]

Wont values return only the existing date according to the filtered product on the product slicer? If so a date may be skiped if it has no entry fir the specific product. So maybe you should have used ALL? Plus why use addcolumns if you can just go with filter( crossjoin , measure> 0 && notblank) ?

[@christertvedt]

Hi, great video! I am trying to run this approach on a dataset of 2,6 million rows (3 500 unique sales locations) and run out of memory. Any way to easily optimize this measure?

[@EnterpriseDNA]

Hello Christer Tvedt, thank you for posting your query onto our channel. Well for optimization we need to look at your data structure and working of the PBIX file and than only we can judge and provide you the results in terms of optimization. Recently, we started an initiative onto our Community Forum where members can provide their PBIX files by highlighting the formula that needs to be optimized and our expert team will look into this. We're providing a link of that post. Also you can reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Hoping you find this useful and meets your requirements that you've been looking for. Happy Learning!!! forum.enterprisedna.co/t/introducing-a-new-enterprise-dna-initiative-optimization-lab/14821 forum.enterprisedna.co/

[@Victor-ol1lo]

Awsome solution !! Thanks for sharing with us !!

[@MarkCBB86]

Awesome Video, thank you for sharing

[@daominhtri2249]

Hi Sam, How if there are more than one period out of stock and I just want to count number of days of the first period.

[@walidkhlil2872]

Great

[@jryan2119]

Great!! Can I please get raw data or key measure method regarding inventory management?

[@EnterpriseDNA]

Hey J, See here for some ideas on this - blog.enterprisedna.co/?s=Inventory+Management. You'll find downloadable options at the bottom of the blog post to access the data files. P.S. All pbix files can be found in 'Mini Series' modules at Enterprise DNA Online - portal.enterprisedna.co/ All the best, Enterprise DNA

[@efficiencydna897]

great video,thanks

[@sebastienschoonjans9727]

If there was 1 item in stock but before the left side of the slicer, is it taken into account?

[@EnterpriseDNA]

Hello Sébastien, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, your query is not understandable to us here. We request you to please write back to us again by elaborating your query in a more specified manner so that we can assist you. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Subscribe to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@sauravsinha6939]

how to get this Power Bi pbix file ?

[@oscarfigueroa9968]

Great!! Could you share the pbix file please?

[@EnterpriseDNA]

Hi oscar figueroa, thanks for posting your comment in the video. All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks! portal.enterprisedna.co

[@oscarfigueroa9968]

@@EnterpriseDNA can't find it, could you share the direct link to the course?

[@jafarhussain6606]

Hello , Please provide the sample data sets

[@EnterpriseDNA]

Hi Jafar, Thanks for posting your comment in the video. All pbix file/datasets/resource files are available for download in the Enterprise DNA Online, which is accessible via Membership. Check out the link below. Thanks! portal.enterprisedna.co/