Forum Discussion

devika's avatar
devika
Helper II
3 years ago
Solved

Rolling 12 months

Hi all,   I'm trying to calculate rolling 12 months,   Rolling 12months = CALCULATE(    [TotalCases],     DATESINPERIOD('Merge'[CASE_DATE],MAX(Merge_Annual_Mx_Vss[CASE_DATE]),-12,MONTH))   ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    devika , Always use the date table joined with date of your table. If possible use the Window function

     

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

    Rolling Months Formula: https://youtu.be/GS5O4G81fww

     

    Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc

amitchandak's avatar
amitchandak
Super User
3 years ago

devika , Always use the date table joined with date of your table. If possible use the Window function

 

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

Rolling Months Formula: https://youtu.be/GS5O4G81fww

 

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc