Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Average between Years

Hi Guys, peace.    I have a situation that I don't know how to solve.    So, I need to calculate the average between the years and bring this information fixed as a example below, in column MD LY...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , You need to try a measure like

 

Rolling 3 = calculate(AverageX(Values('Date'[Year]),CALCULATE(sum(Sales[Sales Amount]))),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,Year))

 

replace sum sales amount with your measures , sum till year level and then avg.

 

Avg above month level

Rolling 3 = calculate(AverageX(Values('Date'[MONTH Year]),CALCULATE(sum(Sales[Sales Amount]))),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,Year))

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, good night, peace


    I've tryed with Sum, but it's not working. 
    But thanks