Forum Discussion

WalkerGBG's avatar
WalkerGBG
Frequent Visitor
5 years ago
Solved

Cumulative Column based on month and Feature

Hi   Very new still to PowerBI and Dax.  I've been searching for a few days to work out how to get a Running Total (Cumulative) added to my data after loading Example below What I'm hoping you ca...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    This calculated column formula works as well

    Running total = CALCULATE(SUM(Data[ImpactTime]),FILTER(Data,Data[Month]=EARLIER(Data[Month])&&Data[Feature]=EARLIER(Data[Feature])))

    Hope this helps.

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago
you can give this a try.  you will need to create a date table if you dont have one
 
ie 
date = calendarauto () (paste that into a new table)
 
for the new measure
running_total =
var mxdt = max('date'[Date])
var fstdt = min('date'[Date])
var lst = CALCULATE(max(cummulativetotal[Month]), REMOVEFILTERS())
var result = if(fstdt <= lst, CALCULATE(sum(cummulativetotal[ImpactTime]), 'date'[Date] <= lst)) return result