Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

calculate rolling over

Hello,   Hope anyone can help? I need to create a new measure to calculate the rolling leavers for a period of time. I have the number of leavers on a monthly basis but not sure how to create a fo...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous ,

    Try like

    Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(Sales[Sales Date]),-12,MONTH))
    Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date Filer],MAX(Sales[Sales Date]),-12,MONTH))