Uniqe table caming from three tables

[MKPartner]

Hi Team, 

I have three tables which aren't in relation but has the same column "mfg_ord_no". I'd like to make from each one combined separate table with only one columnt with only uniqe values. Is there possibility to do it ? 

[amitchandak · Accepted solution]

@MKPartner , You can create common table

distinct(union(distinct(Table1[mfg_ord_no]),distinct(Table2[mfg_ord_no]),distinct(Table3[mfg_ord_no])))

and join with three tables to analyze together

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...