Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Here is an approach that you can make it work:
1] Group By on the first two columns
2] the remaining column is set to all rows
Now the data is segregated, you would need to Sort( distinct())
After you should see a list of values, make sure they are all text (change data type to text)
Then Text.Combine( list, ", " )
To wrap it up:
GroupBy Name, Category with All Rows
Here is an approach that you can make it work:
1] Group By on the first two columns
2] the remaining column is set to all rows
Now the data is segregated, you would need to Sort( distinct())
After you should see a list of values, make sure they are all text (change data type to text)
Then Text.Combine( list, ", " )
To wrap it up:
GroupBy Name, Category with All Rows
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |