Forum Discussion

aallman's avatar
aallman
Icon for Helper II rankHelper 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] )
   )
)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
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] )
   )
)
SachinNandanwar's avatar
SachinNandanwar
Icon for Impactful Individual rankImpactful Individual
1 year ago

I think he mentioned that he has tried UNION and it didnt work for him.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    1 year ago

    SachinNandanwar understood but not sure how he used it, without knowing hard to tell. The expression I gave will work 100%.