Forum Discussion
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
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
2 Replies
- Stachu
Community Champion
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