How to create a table with 2 columns from another table, something like VALUES(), but with 2 columns

[gluizqueiroz]

I have the following table:

ALL DATA

Team	Name	Age	Country
NYG	Jonh Doe	17	USA
NYG	Jonh Doe	22	Canada
NYG	Claire	13	Bolivia
DAL	James	34	Mexico
DAL	James	74	China
PHI	Mary	23	Japan
PHI	Claire	11	USA
NE	Mary	57	England

I have to create a table with unique values from 2 columns, like following:

UNIQUE TEAM-NAME

Team	Name
NYG	Jonh Doe
NYG	Claire
DAL	James
PHI	Mary
PHI	Claire
NE	Mary

[AKNiang]

You can also use Table.Distinct(Query[Column1][Column2]) in Power Query

[Zubair_Muhammad · Accepted solution]

@gluizqueiroz

One way is to create a calculated table from modelling tab

Calculated Table =
ALL ( Table1[Team], Table1[Name] )

or in the query editor...Duplicate the Query..select the 2 columns and choose GroupBY