Forum Discussion
Persons in the same team
Hi all, I have a table with two columns. In the first column are names and in the second column the corresponding team. I would like a third column in which all teammates in the same team are li...
Let's assume your table is called "Teammates" with columns "Name" and "Team". You want to add a calculated column named "Teammates List" that lists all teammates in the same team.
create a calculated column as below:
Teammates List =
VAR CurrentTeam = Teammates[Team]
RETURN
CONCATENATEX (
FILTER ( Teammates, Teammates[Team] = CurrentTeam ),
Teammates[Name],
", "
)
If this helped, Follow this blog for more insightful information about data analytics
https://analyticpulse.blogspot.com/
Please Subscribe AnalyticPulse on YouTube for future updates:
https://www.youtube.com/@AnalyticPulse
Please subscribe CogniJourney On Youtube For Daily fun facts:
https://www.youtube.com/@CogniJourney