Forum Discussion

MBWATSON's avatar
MBWATSON
Icon for Helper II rankHelper II
4 years ago
Solved

Appending Queries with columns added through Dax

Hello! I have two tables with identical columns, three of which were added to each table using DAX. When I attempt to append them, the additional columns do not appear. Is it possible to combine the ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    MBWATSON Sure, in the Modeling tab of your ribbon, choose New table (in Report view) then just use the formula:

    Combined Table = UNION('Table1', 'Table2')
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

MBWATSON Sure, in the Modeling tab of your ribbon, choose New table (in Report view) then just use the formula:

Combined Table = UNION('Table1', 'Table2')
MBWATSON's avatar
MBWATSON
Icon for Helper II rankHelper II
4 years ago

Greg_Deckler that worked perfectly! Again, thank you!!