I need to do a rolling average and I’m struggling in a Tabular model for PowerBI
Here is my scenario. It’s a HR solution. YTD count employee needs to be a rolling average. i.e Sum of employee divided by the fiscalmonth number so for November it should be 325.5 then the attrition should be the average employee count divided by the CountTerminate. I’m stuck - I’m lost somewhere in the context etc, I think

This is my calc for YTD Count Employee - Please help me to change that to a rolling average for financial year

Hi
I managed to get a solution using your videos and some gymnastics

so this gave a cumulative average of the monthly employee count
I created a separate column from the date in the employee snapshot table called MonthNumber, then did a distinct count of all selected dates to use in the calc, so that I would get the number of months so far for the financial year

The ALL function is going back to the very first date of you date table and data regardless of the time frame you have selected. Just something to consider