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.
SachinNandanwar
Impactful Individual
Impactful IndividualWhy do you have so many duplicates in the data ?
In the image below, I highlghted duplicates only for one month..There are hunderds of such duplicates.
SabHelper V
Helper VBecause there are many other columns that prevent removing duplicates (for other calculations). thanks for taking time to look at it though!