Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
Solved! Go to Solution.
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.
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.