Forum Discussion
Solved
How to create a table with 2 columns from another table, something like VALUES(), but with 2 columns
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 |
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
2 Replies
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
You can also use Table.Distinct(Query[Column1][Column2]) in Power Query
