Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |