Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |