Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a table looks like this:
There are 6 extra columns indicating different customer IDs and locations under the same user.
What I would like to achieve is to spit these 6 columns in to three rows, like this:
Please help
Solved! Go to Solution.
Hi @dgdgdg122db ,
Check this file: Download PBIX
I assumed the column "customer_ids/22" is like "customer_ids/22/region" like the others.
If no, let me know.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |