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.

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

WalkerGBG 

maybe you can try to create a column

Column = CALCULATE(sum('Table'[ImpactTime]),ALLEXCEPT('Table','Table'[Month],'Table'[Feature]))