Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
@Anonymous , Create a new measure like this and use in visual
concatenatex(Table, Table[participated] , " " )
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.