Grouping rows of text in an existing column into a new column

[Anonymous]

I have a column in my Incident table named [CreatedBy].  This field contains the login ID of the user who created the incident.  I want to group the CreatedBy login ID's into individual teams.  Utimately what I'm trying to accomplish is tell whether a particular team opened the incident or not.  So I really want to end up with a [CreatedByTeam] column, which sadly doesn't exist in the table.

I've tried using the COMBINEVALUES function, which kind of gets me there, but doesn't do the "grouping" I'm looking for.

Thanks in advance for your help!

[amitchandak]

@Anonymous , if you have a user and group table, joined with your table on user id.

And then when you analyze data by created date, visual grouped on user group should give that data

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.