cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pille Frequent Visitor
Frequent Visitor

Moving average based on indexed data.

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

Screenshot_1.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Moving average based on indexed data.

See my Quick Measure for Time Intelligence "The Hard Way" here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


2 REPLIES 2
Super User
Super User

Re: Moving average based on indexed data.

See my Quick Measure for Time Intelligence "The Hard Way" here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

 

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
Pille Frequent Visitor
Frequent Visitor

Re: Moving average based on indexed data.

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.