90 moving total | average based on indx number

[parminderkellah]

Hi Experts

i am trying to work out the 90 day moving / rolling average based on the index number that corresponds to a date in my FCt table. the values are correct for the first 90 days - come day 91 the value all go wrong. cannot see the wood for the trees.

90 days running total sales = 
VAR MaxIndex = MAX( 'BioSales'[Index]) -- Ending period
VAR MinIndex = MaxIndex - 90             -- Starting period
VAR Result = 
     CALCULATE(
          [Correlation Coefficient],
          -- return dates between starting and ending period
          FILTER( ALL( 'BioSales' ),  
                  'BioSales'[Index] <= MaxIndex &&  
                  'BioSales'[Index] >  MinIndex )
     )
RETURN
     Result

[Greg_Deckler]

@parminderkellah Better Rolling Average - Microsoft Power BI Community