Forum Discussion

Frequent Visitor

5 years ago

Solved

Not able to create a monthly moving average based on a calculated turnover percentage

Hi everyone, I hope this community can help me with a solution to my problem. My googling have not yet given any results unfortunately. My problem is: I have a report named 'HR Trended Turnover'...

Need Help

AndreBV
5 years ago
Hi!
your solution worked out prefectly, even with my filters!
Thank you very much. Appreciate your help!

V-lianl-msft

Community Support

5 years ago

Try:

Measure = 


CALCULATE(
    AVERAGEX(VALUES(Kalender[Month-Year]),[Total turnover precentage]),
    FILTER(ALL(Kalender),
        COUNTROWS(
            FILTER(Kalender,
            Kalender[month year]>=EARLIER(Kalender[month year])
            )
        )
    ),DATESINPERIOD(Kalender[Date],TODAY(),-6,MONTH)
)