Forum Discussion
Solved
Calculating average over multiple tables
I am trying to calculate a total monthly average from data in two seperate tables. This seems like it should be easy, but I cannot figure out the proper DAX formula. Please help! Here's what the data...
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.