Forum Discussion

ermuelle's avatar
ermuelle
Regular Visitor
8 years ago
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...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

I would probably use something like:

 

AVERAGEX(UNION(Table1,Table2),[Score])
Barrizm's avatar
Barrizm
New Member
2 years ago

Just what I was looking for.

thanks