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 am having an issue extracting the latest 4 points of a measure. The measure I used is a rolling average and its function is as follows:
Moving_Average =
Solved! Go to Solution.
Hi Jimmy,
Thanks for answering.
Applying Filter function actually interrupt with the moving average and turn the output back to standalone points.
But applying the filter directly without the Filter function seem to work in this case.
Result = VAR Last_4_Roll_4 = CALCULATE ( [Moving_Average], 'table'[Quarter_Order] <= 4 ) RETURN Last_4_Roll_4
Thanks,
TS
@Anonymous,
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Regards,
Jimmy Tao
Hi TXTS23,
Modify your measure as below and check if it can work:
Result = VAR Last_4_Roll_4 = CALCULATE ( [Moving_Average], FILTER ( 'table', 'table'[Quarter_Order] <= 4 ) ) RETURN Last_4_Roll_4
Regards,
Jimmy Tao
Hi Jimmy,
Thanks for answering.
Applying Filter function actually interrupt with the moving average and turn the output back to standalone points.
But applying the filter directly without the Filter function seem to work in this case.
Result = VAR Last_4_Roll_4 = CALCULATE ( [Moving_Average], 'table'[Quarter_Order] <= 4 ) RETURN Last_4_Roll_4
Thanks,
TS
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |