Forum Discussion
Calculation 12 months slide
Hello, I want to do a calculation over a rolling period of 12 months on Power BI. I would like to retrieve this measure for each month over a rolling 12-month average measure that I already have.
For example, if I select the month of December 2023, I retrieve the last 12 values (from previous months = December 2022) of averages and divide by 12 the whole.
I have already try this but it's return me only the [TotalAverage] values :
CALCULATE(
([TotalAverage]),
DATESINPERIOD('SourceMCP'[Month], MAX('SourceMCP'[Month]), -12, MONTH)
)
1 Reply
Try a Quick Measure
