Microsoft Power BI Complete Reference

Rolling periods

Rolling period and trailing average measures are also very common in datasets, as they help to smooth out individual outliers and analyze longer-term trends. For example, a significant business event or variance 10 months ago will have a relatively small impact on a trailing 12 month total. Additionally, this variance will not impact trailing 30 day or 3, 6, and 9-month rolling period measures.

The following two measures capture the trailing 60 days of sales history and the 60 days of history prior to the trailing 60 days:

Internet Net Sales (Trailing 60 Days) = VAR MaxDate = MAX('Date'[Date])VAR StartDate = MaxDate - 59RETURNCALCULATE([Internet Net Sales],FILTER(ALL('Date'),'Date'[Date] >= StartDate && 'Date'[Date] <= MaxDate)) ...