Create a new table from columns from existing tables with unique value

[mauroanelli]

i'm looking to do something like 

https://community.powerbi.com/t5/Desktop/Create-a-new-table-from-columns-from-existing-tables/m-p/98...

and the dax formula

Type = UNION(SELECTCOLUMNS(ICS_BI_Reports;"Tipo";ICS_BI_Reports[Tipo]);SELECTCOLUMNS(ICS_Budget;"Tipo";ICS_Budget[Tipo]))

works fine.

now i would like to use this table as relation for other tables so i need unique value, no duplicate.

any suggestion?

thanks

[quentin_vigne · Accepted solution]

Hi @mauroanelli

Try to create a new table with Table = Distinct(PrimaryKeyWanted)

This new table will be used to make the link between two tables

- Quentin