Forum Discussion

TotalAnonymous's avatar
TotalAnonymous
Icon for Helper III rankHelper III
11 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
    11 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
11 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
    11 months ago

    Hi amitchandak , 
    Please let me check and get back to you ASAP. Thank you for your help!

  • TotalAnonymous's avatar
    TotalAnonymous
    Icon for Helper III rankHelper III
    11 months ago

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