How to group values from a column based on the value of another one

[fernandoC]

Hi!

Wanted to reach out as I´ve been trying to find a way to achieve the following:

I have a table that has the following structure

Name	Skill
John Doe	Java
John Doe	.NET
Michael Jordan	Python
Michael Jordan	Scala

I would like to have the following outcome

Name	Skill
John Doe	Java/.NET
Michael Jordan	Python/Scala

Thank you for your assistance.

Best, 

[v-yalanwu-msft · Accepted solution]

Hi, @fernandoC ;

You could create a measure or column :

1.create a measure.

Measure = CONCATENATEX(FILTER(ALL('Table'),[Name]=MAX('Table'[Name])),'Table'[Skill], "/")

2.create a column.

Measure = CONCATENATEX(FILTER(ALL('Table'),[Name]=MAX('Table'[Name])),'Table'[Skill], "/")

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@fernandoC , Create a measure and use it with name, in visual

measure = concatenatex(Table, Table[Skill], "/")

[fernandoC]

Hi @amitchandak 

I tried using a measure but I'm not getting the expected results. When used in a table visual the results are not being grouped based on the Name. Any suggestions?.