Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
DataMonkey101
Frequent Visitor

What is the formula that you tried using Dax?

nhol
Advocate II

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.