Forum Discussion

aallman's avatar
aallman
Helper II
1 year ago
Solved

Combine Multiple Summary Tables into One

Hello!   I currently have 3 queries pulling from different sources. I have summarized each of these into summary tables that contain the ID column. All I need to do is get a comprehensive list of I...
Need Help
  • parry2k's avatar
    parry2k
    1 year ago

    aallman assuming your 3 tables called table 1, table 2 and table 3

     

    you can use following DAX to create a new tables:

     

    ID Table = 
DISTINCT (
   UNION ( 
       SELECTCOLUMNS ( Table1, "Id", Table1[Id] ),
       SELECTCOLUMNS ( Table2, "Id", Table2[Id] ),
       SELECTCOLUMNS ( Table3, "Id", Table3[Id] )
   )
)
aallman's avatar
aallman
Helper II
1 year ago

thank you this worked! I was not doing distinct and I think that was messing it up.