Forum Discussion
Running total
Hello,
I need assistance with a formula for running total. I am using the formula below, but as you can see from the screenshot, the running total is not being calculated. What am I doing wrong?
RT_BUD_CL = TOTALYTD ( SUM('Summary Query'[BUD CL]), 'Summary Query'[DATE].[Date] )
'Summary Query'[BUD CL] is the value column
'Summary Query'[DATE] is the date column
@Seth_OttoBros, What an annual total and measure
Total measurement running with date table
Cumm ? CALCULATE(SUM('Summary Query'[BUD CL]),filter(allselected(date),date[date] <-maxx(date,date[date])))
Cumm ? CALCULATE(SUM('Summary Query'[BUD CL]),filter(allselected(date),date[date] <-max('Summary Query'[DATE])))Como una nueva columna
Cumm á CALCULATE(SUM('Summary Query'[BUD CL]),filter('Summary Query','Summary Query'[DATE] <-earlier('Summary Query'[DATE] )))To get the best out of the time intelligence function. Make sure that you have a date calendar and that it has been marked as the date in the model view. Also, join her with the date column of your events. See :radacad sqlbi My Video Series Appreciate your congratulations.
2 Replies
@Seth_OttoBros, What an annual total and measure
Total measurement running with date table
Cumm ? CALCULATE(SUM('Summary Query'[BUD CL]),filter(allselected(date),date[date] <-maxx(date,date[date])))
Cumm ? CALCULATE(SUM('Summary Query'[BUD CL]),filter(allselected(date),date[date] <-max('Summary Query'[DATE])))Como una nueva columna
Cumm á CALCULATE(SUM('Summary Query'[BUD CL]),filter('Summary Query','Summary Query'[DATE] <-earlier('Summary Query'[DATE] )))To get the best out of the time intelligence function. Make sure that you have a date calendar and that it has been marked as the date in the model view. Also, join her with the date column of your events. See :radacad sqlbi My Video Series Appreciate your congratulations.