Forum Discussion
StuartSmith
4 years agoPower Participant
Matrix Running Total per Month (Example file included)
I have a matrix that shows values per month... the predicted heacount, available laptops and then remaining laptops (laptops - headcount). Is there a way to get a running total for the remaining lap...
- 4 years ago
Hi, StuartSmith
Please still use the formula I provided above, but replace the ALLSELECTED function with the ALL function.Result:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-angzheng-msft
4 years agoCommunity Support
Hi, StuartSmith
Try this:
Predicted_Headcount_Measure = COUNTROWS('HR Data') + 02022_Total_Laptops =
Var _start=CALCULATE(SUM('Buffer Stock - Current Stock'[Buffer Stock]))+CALCULATE(COUNTROWS('Full Laptop Table'))
var _Running=CALCULATE(COUNT('HR Data'[Start Date]),FILTER(ALLSELECTED('HR Data'),'HR Data'[Start Date]<Min('HR Data'[Start Date])))
return _start-_Running2022_Remaining_Laptops =
Var _start=CALCULATE(SUM('Buffer Stock - Current Stock'[Buffer Stock]))+CALCULATE(COUNTROWS('Full Laptop Table'))
var _Running=CALCULATE(COUNT('HR Data'[Start Date]),FILTER(ALLSELECTED('HR Data'),'HR Data'[Start Date]<=Max('HR Data'[Start Date])))
return _start-_Running
Result:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.