Forum Discussion
Pille
8 years agoFrequent 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 wh...
- 8 years ago
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-TITHW/m-p/434008
It is date-centric but can be easily adapted to an index.
Greg_Deckler
8 years agoCommunity Champion
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-TITHW/m-p/434008
It is date-centric but can be easily adapted to an index.
Pille
8 years agoFrequent Visitor
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.