Forum Discussion

MBWATSON's avatar
MBWATSON
Icon for Helper II rankHelper II
3 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
    3 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
3 years ago

Greg_Deckler thank you for that information! Nothing that I have researched has mentioned using Union in DAX. I will attempt it and let you know how it goes.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 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
    3 years ago

    Greg_Deckler that worked perfectly! Again, thank you!!