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.
Hi,
I am totally new to Power BI and have a simple question to show inventory forecast
I have:
Starting inventory by sku -->
Solved! Go to Solution.
Hi, @steff131284
Please try the below.
Forecast =
CALCULATE (
[Bestand],
FILTER ( ALLSELECTED ( DateTable ), DateTable[Date] <= MAX ( DateTable[Date] ) )
)
+ CALCULATE (
[Delta],
FILTER ( ALLSELECTED ( DateTable ), DateTable[Date] <= MAX ( DateTable[Date] ) )
)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @steff131284
Thank you for your feedback.
Is your question, "show the last month ending inventory on this month" ?
Please check the link down below, whether it is what you are looking for.
https://www.dropbox.com/s/dugrnjye58e8orh/Reichweiten%20-%20Kopie.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
How can I share it, file type pbix is not supported?
Hi, @steff131284
Please try the below.
Forecast =
CALCULATE (
[Bestand],
FILTER ( ALLSELECTED ( DateTable ), DateTable[Date] <= MAX ( DateTable[Date] ) )
)
+ CALCULATE (
[Delta],
FILTER ( ALLSELECTED ( DateTable ), DateTable[Date] <= MAX ( DateTable[Date] ) )
)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
This works perfectly
Can you explain, what this formula does? I do not understand the syntax 🙂
Hi,
Thank you for your feedback.
The different part is, I think, the below.
FILTER ( ALLSELECTED ( DateTable ), DateTable[Date] <= MAX ( DateTable[Date] )
The above is working in the CALCULATE function.
1. selects all dates in the date table
2. defines the range of the dates that are less than or equal to the current context date ( = current row's date).
3. Sums up all that are inside the date range defined by the above.
It actually does the same job as MTD, QTD, or YTD, but there is no restriction unless you define it by an outside date-slicer.
If you also want not to be restricted by an outside date-slicer, for instance, if you want to sum up from all the way from the beginning (eg. Jan), even if you selected time range from Mar., then you can simply replace ALLSELECTED to ALL.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi Kim,
I have one follow up question.
I now what to calculate my Days of stock.
With your formula I calculated the stock at the end of the month.
Now I want to divide this number by the Sales volume of the next month
What do I need to add, so Power BI is using the value for the next month and not for the current month? So far my formula is
Hi, @steff131284
If it is OK with you, please share your sample pbix file's link here, then I can try to look into it to come up with an accurate solution.
Thanks.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
How can I share it, file type pbix is not supported?
Hi, @steff131284
Please save your file in Onedrive or googledrive, and you can share the link here.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @steff131284
Thank you for sharing.
I am not quite sure if I understood your question correctly. I just calculated the next month's sales. Then, created the final measure. Those are the belows.
Please check the link down below as well.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
This is perfect, although I have no idea what this formula does 🙂
Last thing. What do I need to do, that also my startig inventory is shown for all months?
Hi, @steff131284
Thank you for your feedback.
Is your question, "show the last month ending inventory on this month" ?
Please check the link down below, whether it is what you are looking for.
https://www.dropbox.com/s/dugrnjye58e8orh/Reichweiten%20-%20Kopie.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you so much
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |