Running Total split by categories

[MrSnowman98]

Hi guys,

Can anybody help me to set up running totals by categories for a matrix table? Something like that the one below. I have tried quick measure for running total but it doesnt not work...

Currently the values that I have is the change in headcount per month for each function and subfunction.

I have the following fields:

Function (HR, Finance)

Sub-function (Talent, Recruiting, Treasury,  Accounting)

Head-count (Change in headcount per month)

Date

Also, is there a way to show the running total for months that do not have any movement? As I noticed that it will become a blank space when there is no movement.

Thank you!

[v-xiaotang]

Hi @MrSnowman98 

Could you share some sample data( you can replace raw data with bogus data) and the expected result based on the sample data? Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523