Forum Discussion
Matrix Running Total per Month (Example file included)
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.
Hi StuartSmith can you share some sample data to work with? Or better - a pbix with the data model.
Thanks for getting back to me. Find a "Dropbox Link" to a demo file, with a similar setup to the working file.
So in the attached example, for Jan there are 31 "Total Laptops" available with 3 "Predicted Headcount", leaving 28 "Remaining Laptops". Therefore, for Feb, the "Total Laptops" column should show the same figure as Jan's "Remaining Laptops" figure of 28, and Febs "Remaining Laptops" value should be 26 (Feb Total Laptops - Feb's Predicted headcount. 😀
Hope that makes sense, but basically just want a running total of available laptops after the months new starters.