Forum Discussion
12 months average
Hi all, I have req as doing average for each month Before I was showing count (I'd) for each date, mknth, year Now I want to show average like In Jan if I have count of id 700 then avg will b...
hi, Anonymous
update code of all('calender date')
remove update code of all('calender date'[date]) -- remove red part from all and put all('calender date')
Hi, Thanks for replying
when I select 2022 year the avearge of each month is like below
When I select 2023 in year (open_date) the 12 months rolling average is like below
But when I didn't give any filters and want to check respective years 12 months rolling averages it's changing , like below
I want to show rolling avearges for every year separately in trends
Please reply
Thanks in advance