cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
syntaxislost
Frequent Visitor

How to get Cumulative Employee Tables per Fiscal year

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 Employee COunt.PNG

1 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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
louisvp
Helper II
Helper II

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
Microsoft
Microsoft

Hi @syntaxislost,

 

Could you please mark the proper answer as a solution?

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Heres the DAX:

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

 

Heres Sample Data:

 

SampleData Extend.PNG

Hi @syntaxislost,

 

Try this one please.

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

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors