Forum Discussion

BENJO's avatar
BENJO
Regular Visitor
2 years ago

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...
Need Help
AnalyticPulse's avatar
AnalyticPulse
Solution Sage
2 years ago

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


  • BENJO's avatar
    BENJO
    Regular Visitor
    2 years ago

    Hey AnalyticPulse,

     

    thanks for the quick response.

    What do you mean with calculated column? Custom Column? I get an error here

     

    Solution for BerLIN: autumn,AAAAY, Lysoar, Life

    Solution for autumn: BerLIN,AAAAY,Lysoar,Life

    • AnalyticPulse's avatar
      AnalyticPulse
      Solution Sage
      2 years ago

      calculated columns means the on eyou add in data view mode from data modeling tab, not inn power query

      • BENJO's avatar
        BENJO
        Regular Visitor
        2 years ago

        Thanks, that worked. But I want the Name in the row to not be in the Teammates List. Is that possible?

        I also would like to do it within the power query editor, is that possible aswell?