Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Hi @syntaxislost,
Could you please mark the proper answer as a solution?
Best Regards,
Dale
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
Heres the DAX:
Running Total Measure = CALCULATE( COUNTA(Data[StaffLevelName]), FILTER(Data,Data[FiscalStartYear] <= MAX(Data[FiscalStartYear])))
Heres Sample Data:
Hi @syntaxislost,
Try this one please.
Running Total Measure = CALCULATE ( COUNTA ( Data[StaffLevelName] ), FILTER ( ALL ( Data ), Data[FiscalStartYear] <= MAX ( Data[FiscalStartYear] ) ) )
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |