Forum Discussion

dbadmin's avatar
dbadmin
Icon for Advocate V rankAdvocate V
10 years ago
Solved

How to calculate Moving Average based on a Rolling 10 hours

 I have a table that lists the Date, Time and SPMs. I need to calculate the MOVING Average for the SPMs column. I have tried all the different sites - but can't seem to find one that will work for wh...
Need Help
dbadmin's avatar
dbadmin
Icon for Advocate V rankAdvocate V
10 years ago

THANK YOU!!!! I'm not very familiar with DAX at all - so I didn't even know to look for EARLIER. It works like a charm. Much simpler than what I was trying to come up with. :)

 

Thank you again so much!! I've been working on this one off and on for weeks now. 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Happy to help, and for the record, EARLIER is a dumb name for that function IMHO considering how it is most often used. I would have gone with something like CURRENT.