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))

Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi TotalAnonymous ,
I would take a moment to thank amitchandak , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions