topic Re: measure to visualize day out of stock in DAX Commands and Tips

measure to visualize day out of stock

Anonymous — Wed, 11 Aug 2021 13:55:10 GMT

I am trying to create a visual that shows what day a product will run out. both files are linked with Sap product code and the couplings. current stock is the available stock for the code while q_pieza is the number of order for that code. The visual i am trying to build will show if x amount is ordered then with the current stock, the couplings will be done on this day. i belive i need to write a measure to get that visual considering the current stock doesnt have a date attached. any sort of help will be appriciated and if it is confusing let me know and i will edit it. Thank you in advance

Re: measure to visualize day out of stock

Greg_Deckler — Wed, 11 Aug 2021 14:16:07 GMT

Anonymous I did something similar to this, Days of Supply: https://community.powerbi.com/t5/Quick-Measures-Gallery/Days-of-Supply/m-p/635656#M318

Re: measure to visualize day out of stock

Anonymous — Wed, 11 Aug 2021 19:13:34 GMT

Greg_Deckler thank you for your response and i appreciate the effort but that has nothing to do with what i am trying to do

Re: measure to visualize day out of stock

Greg_Deckler — Thu, 12 Aug 2021 14:37:40 GMT

Anonymous OK, then will need sample data and expected output.

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.