Forum Discussion
Pfoerster
Helper III
6 years agoNeed help with Total Line for Stocks
Hello,
I am a Beginner in Power BI and want to create an Overview of monthly stocks. So I have createad a Matrix, where I have the "Stock Begin", "Gross Production", "Sales", "Stock End" per month (each month is a line).
Now, I also want to show in this Matrix the YTD result but do not have a glue, how to do it: If I use the Total Sum from Power BI, the Starting, Ending and Average Stock is wrong, because it is the Sum of each Starting Stock per month, but:
YTD Starting Stock = January Starting Stock
YTD Ending Stock = December Ending Stock
YTD Average Stock = (January Starting Stock + Ending Stock per month) / (Amount of Month +1)
How can I do it, within my existing Matrix. Thank you for your help.
1 Reply
- V-lianl-msft
Community Support
Hi Pfoerster ,It is very difficult to analyze without looking at the data and just by imagining. See if you can paste the image or table representing any sample data.Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.