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, anyone could help me with calculate inventory at the end of the day, and then use it for initial inventory the next day
This is a monthly report , i have initial inventory as a fixed number, i have all productions and consumptiosn defined. IT's easy in excel to achieve this, but i'd like to try some What if analysis so i need to model this in PowerBi
All data in green is a information i got as a input, without change during month.
It's some kind of budget, then i would have to create the actual values and compare them. But i'm having troubles with this,
thank you in advance,
I tried measures and prev day, but doesnt' seem to work the way i want.
Solved! Go to Solution.
Hi, @plaralema ;
You could try it.
Final Inventory =
27389
+ CALCULATE (
SUM ( [Production] ) - SUM ( 'Table'[Consumption 1] )
- SUM ( 'Table'[Consumption 2] )
- SUM ( 'Table'[Consumption3] ),
FILTER ( ALL ( 'Table' ), [Date] <= MAX ( 'Table'[Date] ) )
)
Initial Inventory = CALCULATE([Final Inventory],FILTER(ALL('Table'),[Date]<MAX('Table'[Date])))
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @plaralema ;
You could try it.
Final Inventory =
27389
+ CALCULATE (
SUM ( [Production] ) - SUM ( 'Table'[Consumption 1] )
- SUM ( 'Table'[Consumption 2] )
- SUM ( 'Table'[Consumption3] ),
FILTER ( ALL ( 'Table' ), [Date] <= MAX ( 'Table'[Date] ) )
)
Initial Inventory = CALCULATE([Final Inventory],FILTER(ALL('Table'),[Date]<MAX('Table'[Date])))
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much I really appreciate your time to answer. Best Regards
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please indicate if this needs to be done in DAX or if it can be done in Power Query.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |