Average cost Calculation via Custom calculation

Summary:

Hi All,

We need to calculate a rolling 6-month average cost per unit based on monthly data.

For the current period (June), the calculation should consider January to June

For July, it should automatically shift to February to July, and so on

The calculation must be fully dynamic, updating automatically each month without manual intervention

The calculated average should be stored in a single member (for example, Avg_Per_Unit)

The result should be displayed in the current month only (e.g., in June the Avg cost per unit is visible only in June)

When I run the model let say for POV-FY25,JAN,Working,Actual. It will dynamically calculated (Current Month+FY25) + (Remaining 5 month form FY24 i.e DEC,NOV,OCT,SEP,AUG).