Forum Discussion
Sab
Helper V
Helper VCalculater average for previous 12 months
Hello guys, I need to calculate the avg of a column for the filtered values between the max date in the slicer (in this case 31 July 2024), going back 1 year (so from 1 Aug 2023), for the unique val...
Hi Sab
Although the measure had written so complicated but anyway, you should add an "all" before Deviation!
....filter (summarize (all(deviations) , ........
If this post helps, then I would appreciate a thumbs up 👍and mark it as the solution to help the other members find it more quickly.
Selva-Salimi
Solution Sage
Solution SageHi Sab
Although the measure had written so complicated but anyway, you should add an "all" before Deviation!
....filter (summarize (all(deviations) , ........
If this post helps, then I would appreciate a thumbs up 👍and mark it as the solution to help the other members find it more quickly.