Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
i have the following data set at SKU-location level: 1)period 2)stock quantities in cases 3) 8 columns of weekly forecast in CS (week 0 to week 7).
Based on that, i need to calculate days on hand / weeks on hand at each period at any selected level of product hierarchy (SKU or higher level) and any aggregation of storage locations
Please help me with the ideas on how it can be delivered. Thanks a lot in advance
Solved! Go to Solution.
@vitalities,
Please check if DAX in the attached PBIX file returns your expected result.
Regards,
Lydia
@vitalities,
Please check if DAX in the attached PBIX file returns your expected result.
Regards,
Lydia
@vitalities,
Please follow the instructions in the thread below to provide sample data of your table here and post expected result.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Lydia
Here it is. Stock and forecast are in same units. I need a measure to calculate how many days of forecast will be covered with stock we have
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |