Union 3 tables

[Anonymous]

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

[Stachu · Accepted solution]

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

[Anonymous]

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