Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have multiple values in one row and am not able to do it. Please see the below data.
Users Groups
John Everyone
Finance
Warehouse
Stores
Scott Everyone
Finance
Warehouse
Stores
I want to get the result below.
Users Groups
John Everyone
John Finance
John Warehouse
John Stores
Can you please help me? I was trying to group all users. I have many users in the finance group. It just an example when I group finance, I can get a count 2 user
Thanks
Solved! Go to Solution.
Ah ok - then you'll have to use Split column by delimiter (in Power Query) and you have to choose/type #lf (line feed) as a delimiter
Thanks for your reply, User and group is one row, but the second column has multiple group names in the row. i did not get how I can do this.
Ah ok - then you'll have to use Split column by delimiter (in Power Query) and you have to choose/type #lf (line feed) as a delimiter
Thanks, It worked!!
You can use the Fill Down transformation in Power Query. Note that you have to replace the blank values in the Users column with "null". Without that first step the "Fill Down" will not work.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |