Solved: Moving average based on indexed data.

Pille · ‎07-25-2018

Hi,

I'm new to Power BI and I have been reading about the sollutions on moving averages and see that they are filtered by date.

I would like to build a measure filtered by index instead. Using a whatif table for the periods of the moving average. I got a little lost here.

Kind Regards

Pille

Greg_Deckler · ‎07-25-2018

It is date-centric but can be easily adapted to an index.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Greg_Deckler · ‎07-25-2018

It is date-centric but can be easily adapted to an index.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Pille · ‎08-06-2018

Hey thanks Greg, you got me thinking in a different direction and really trying to learn how the filter function works. Got it now.

Kind regards.

Moving average based on indexed data.