Forum Discussion
gluizqueiroz
Resolver I
Resolver IHow 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 C...
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