Forum Discussion

Greger1337's avatar
Greger1337
Frequent Visitor
9 years ago
Solved

Keep cumulative sum when filtering

I having trouble with my cumulative sum. I have data from 29 months and I am calculating a rolling sum for the last 12 months like this: Ackumu rullande 12 månader omsättning = CALCULATE([Omsättni...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Try adding another filter, ALL() to your CALCULATE().

     

    CALCULATE([Omsättning],ALL('BFO Transactions','BFO Transactions'[Date]),DATESINPERIOD…)

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Try adding another filter, ALL() to your CALCULATE().

 

CALCULATE([Omsättning],ALL('BFO Transactions','BFO Transactions'[Date]),DATESINPERIOD…)

 

  • Greger1337's avatar
    Greger1337
    Frequent Visitor
    9 years ago

    Thank you!

    Ackumu rullande 12 månader omsättning = 
CALCULATE([Omsättning]; ALL('BFO Transactions'[Date]);
DATESINPERIOD('Date'[Date]; 
LASTDATE('BFO Transactions'[Date]);-12;MONTH)
)

    This did exacly what I was after.