cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jak82 Member
Member

Union 3 tables

Hi,

 

I have three tables that I need to join together.

 

I know Union works for two tables, but how can I do the same with three?

 

Thanks

 

Chris

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Union 3 tables

in DAX you can do more than 2:

https://docs.microsoft.com/en-us/dax/union-function-dax

you just add another table after a separator

 

it's very similar with Table.Combine in M/Query editor, you just need to type in the formula bar
https://docs.microsoft.com/en-us/powerquery-m/table-combine

1 REPLY 1
Highlighted
Super User
Super User

Re: Union 3 tables

in DAX you can do more than 2:

https://docs.microsoft.com/en-us/dax/union-function-dax

you just add another table after a separator

 

it's very similar with Table.Combine in M/Query editor, you just need to type in the formula bar
https://docs.microsoft.com/en-us/powerquery-m/table-combine