How to get Cumulative Employee Tables per Fiscal year

[syntaxislost]

Im trying to get these tables to stack, so each fiscal year has an adds the employees in previous year and adds the new ones but the cumulative total function isnt working for me. It only sums the new employees addded that year. Need help with DAX or measure or how to approach it differently 

[louisvp]

Dear Community,

I want to create a simular table but then in Power Query using the m Query language.

Could someone help me with this?

When I use the DAX code in Power BI Desktop, my Desktop file beocomes very slowly:

Running total size =CALCULATE (    COUNTA (Data [StaffLevelName]),    FILTER ( ALL (Data) , Data [FiscalStartYear] <= MAX (Data [FiscalStartYear])))

Thank you very much.

Kind regards Louis van Paassen

[v-jiascu-msft]

Hi @syntaxislost,

Could you please mark the proper answer as a solution?

Best Regards,
Dale

[Greg_Deckler]

Can you post sample data and your measure formula?

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[syntaxislost]

Heres the DAX:

Running Total Measure = CALCULATE( COUNTA(Data[StaffLevelName]), FILTER(Data,Data[FiscalStartYear] <= MAX(Data[FiscalStartYear])))

Heres Sample Data:

[v-jiascu-msft · Accepted solution]

Hi @syntaxislost,

Try this one please.

Running Total Measure =
CALCULATE (
    COUNTA ( Data[StaffLevelName] ),
    FILTER ( ALL ( Data ), Data[FiscalStartYear] <= MAX ( Data[FiscalStartYear] ) )
)

Best Regards,

Dale