Forum Discussion

TotalAnonymous's avatar
TotalAnonymous
Icon for Helper III rankHelper III
10 months ago
Solved

Moving Average 3 Months Value - Only Considering Not Blank

Dear Community,  I hope you're doing well. I'm facing an issue with DAX calculation here.  Currently, I'm trying to calculate Moving Average 3 Month value (Past 3 Months value) using this DAX: ...
  • amitchandak's avatar
    amitchandak
    10 months ago

    TotalAnonymous , Try like 

    Rolling 3 = CALCULATE(Averagex(Values('Date'[Month Year]) ,[Latest Value]),DATESINPERIOD('Date'[Date],max('Date'[Date]),-3,MONTH))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
10 months ago

TotalAnonymous , Try like 

Rolling 3 = CALCULATE(Averagex(Values('Date'[Month Year]) ,[Latest Value]),DATESINPERIOD('Date'[Date],max('Date'[Date]),-3,MONTH))

TotalAnonymous's avatar
TotalAnonymous
Icon for Helper III rankHelper III
10 months ago

Hi, amitchandak , thanks for sharing the formula, it works!