Forum Discussion
HELP: Cumulative Running Total
Hello Everyone;
I am seeking help on my power BI report. Ive been wandering in every site searching for possible solution for my problem. I saw some but still could not get it rght. I would like to ask for a help to any power bi expertise regarding on how to create a Cumulative Table. I have tried the below DAX Measure but still i get an error. Need help badly. Thanks
The table should show like on the colored one.
15 Replies
quentin_vigneSolution Sage
Hi Anonymous
Can you try this ? (Replace it with your values for each column wanted, for example for Plan-Execution 'Table'[Column] by the column you want the running total to sum (hope I'm clear)Running Total COLUMN = CALCULATE ( SUM ( 'Table'[Column] ), ALL ( 'Table' ), 'Table'[Worked Date] <= EARLIER ( 'Table'[Worked Date] ) )It should work
- Quentin
Hello quentin_vigne;
Is it correct? I did it but there is an error. the = 'Raw Data(Exe)' is the name of the table
- quentin_vigne
Anonymous
Maybe try to delete all the '
Depending of the country the coma can be ; for a formula to work
- Quentin
Hi Anonymous
I would suggest you to create a master date table (DimDate) first. It will consist of all dates in continuous manner for current year (you can include dates for other years as well).
Create relationship between date field of the master date table (DateID) and date field of your table (Worked Date).
Then, try using the DAX formula-
Measure = CALCULATE(SUM(RawData[Work Category]), FILTER (ALL ( DimDate ),
'DimDate'[DateID] <= MAX ( 'DimDate'[DateID] ))
)Hope this helps.
Regards,
Suguna.