Forum Discussion
Calculating average over multiple tables
Hi,
You must create a calendar table and create a relationship from the Date column of the appended table to the date column of the Calendar Table. In the Calendar Table use the =FORMAT(Calendar[Date],"mmmm") formula to extract the month name from the Date and =YEAR(Calendar[Date]) to extract the Year. In your visual, drag the Year and Month from the Calendar Table.
Hope this helps.
Thanks. I've tried this, but I only get the overall average across the time period. I can't look at it by month. I want to be able to look at the total average (referred + managed satisfaction) by month.
Hi,
You must create a calendar table and create a relationship from the Date column of the appended table to the date column of the Calendar Table. In the Calendar Table use the =FORMAT(Calendar[Date],"mmmm") formula to extract the month name from the Date and =YEAR(Calendar[Date]) to extract the Year. In your visual, drag the Year and Month from the Calendar Table.
Hope this helps.
Thank you! I think I found a solution.
You are welcome.
Hi!
I know it's been ages since this post. But would you happen to have the pbix file? I have almost the exact same question
