Forum Discussion
Constant Average & Cumulative Average
I want to calculate a constant average for weeks from 29 to 41. Test Avg Measure Before Period = AVERAGEX(SUMMARIZE( FILTER( Date_Dim, Date_Dim[FISCAL...
Ashish_Mathur
Super User
Super UserHi,
So in each row of the "Test avg measure before period" you want to see -3283? Am i correct?
Hi Ashish_Mathur ,
Yes, I want to see -3283 for each row of the "Test avg measure before period". I tried using All but if I use all it is going way back till 2019 data. I only want to show for the mentioned weeks -3283 for FY23 W29 to FY23 W41. The table data should start only from FY23 W29. The reason I want this is that I want to add it to a bar chart and show it as W41 which would have -3283 for it and W42 onwards Test Avg Measure After Period logic follows.
- Ashish_Mathur
Hi,
Would you be OK with a calculated column formula (instead of a measure)?
Yes, that would be fine.
- Ashish_Mathur
Hi,
Share the download link of the PBI file.