Reply
Member
Posts: 374
Registered: ‎07-22-2016
Accepted Solution

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


Accepted Solutions
Super User
Posts: 866
Registered: ‎06-23-2016

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

View solution in original post


All Replies
Super User
Posts: 866
Registered: ‎06-23-2016

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