cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating Moving Average

 

Hi,

 

I went thru all community suggestions on how to calculate this and still couldn't figure it out. I'm trying to calculate a MovingAvg (last column marked in yellow) and in addition to calculate MovingSum (column marked in light blue).

Here is the example I made in less than 10 seconds in Excel.

Why it is so hard in DAX??

 

My Excel doesn't represent my entire database and this is just the summary of all Web Page Categories… but you got the idea.

 

Thanks!

MovingAvg.PNG

 

Status: New
Comments
Frequent Visitor

What is the formula that you tried using Dax?

Member

Already deleted it from my model.

But there were couple of ideas that I saw that were using the below functions:

- DATESINPERIOD(Calendar[Date] 

- LASTDATE(Calendar[Date])

 

Not sure if it helps. I can go ahead and try to recover the endless measures I was trying to build... not sure that would help.