I need to show my data like this

[Anonymous]

Hi guys, I am new to Power Bi. I need your help. I have a table which contain three columns id, name and participated

id                               name                         participated 

---------------------------------------------------------------------

1                              Max                              Football       

2                              Peter                            BasketBall

3                              Peter                            Football

4                              Max                              Basketball

5                              Max                              Table Tennis

6                              Anderson                      Football

I need to represent the above table like this 

name                                        participated

-----------------------------------------------------------------------

Max                           Football       Basketball     TableTennis

Peter                         Football        Basketball

Anderson                  FootBall

Thanks

@Helper , @BIHelp 

[Anonymous · Accepted solution]

Don't @Dineshdcoder,

Here are the steps you can follow:

1. Create calculated table.

Table 2 =
SUMMARIZE('Table','Table'[Name],
"participated",CONCATENATEX(FILTER('Table','Table'[Name]=EARLIER('Table'[Name])),'Table'[Participated]," "))

2. Result

You can download the PBIX file from here.

Best regards

Liu Yang

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@Anonymous , Create a new measure like this and use in visual

concatenatex(Table, Table[participated] , " " )