cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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 I
Super User I

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



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Highlighted
Super User I
Super User I

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



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Proud to be a Super User!

View solution in original post

Highlighted

Hi expert, 

I have 3 tables which contained item code - name. I can connect either Sell_in[item code] or Sell_out[item code] to Item[Item code]. Not both. 

Could you please help me solve it. Much appriciate

bbui_0-1598026776884.png

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors