Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello All
I wanted to create a Rate Of Sale (ROS) , Week of Sales (WOS) that is in how many weeks the inventory stock will remain
and to calculate the run out date
The data I have
Expected Output
Thank You!
@v-cgao-msft @amitchandak @Greg_Deckler @lbendlin @Arul @Sahir_Maharaj @Ahmedx
@emma_3 Sorry, having trouble following, can you post sample data as text 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.
@Greg_Deckler
I wanted to show when the stock will become emtpy in weeks, days, and months, as well as the date.
For example
the expect the output should be like
Product | stock gets empty (in weeks) | stock gets empty (in days) | stock gets empty (in date) |
A | 13 | 4 | 03/14/2023 |
B | 14 | 11 | 04/01/2023 |
@emma_3 See if this helps: Days of Supply - Microsoft Power BI Community
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
107 | |
96 | |
92 | |
87 | |
69 |
User | Count |
---|---|
165 | |
130 | |
129 | |
102 | |
98 |