Forum Discussion
Solved
Cumulative Total till today
Hi I want to get cumulative totals according to the dates till today and for all the future dates cumulative total should be shown as zero or blank. I went through some examples but those...
Try this:
Running Total = var __MaxDT = max(Table[Date]) var __Rtotal = CALCULATE(SUM(Table[Value]), Filter(All(Table), Table[Date] <= __MaxDT) ) RETURN IF (__MaxDT > TODAY(), 0, __Rtotal)Hope this helps
David
Alpha1029It needs to be created as a measure, not a calculated column. The measure can be added to a visual table as a column.
dedelman_clng
Community Champion
Community ChampionAlpha1029It needs to be created as a measure, not a calculated column. The measure can be added to a visual table as a column.
Greg_Deckler I tried to create it as measure and still it gives me all zeros . Any suggestions...
Greg_DecklerIt works if I create it as a measure. I was checking it in the wrong place. Sorry for coming to a conclusion so quickly.