Forum Discussion
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)) ...
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
Thanks, amitchandak, for your reply and for sharing your knowledge; it worked when I joined the data table.