Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
How can I transform a single column hierarchy like this
1 | Name 1 |
11 | Name 11 |
111 | Name 111 |
112 | Name 112 |
12 | Name 12 |
121 | Name 121 |
122 | Name 122 |
2 | Name 2 |
21 | Name 21 |
211 | Name 211 |
into something like this
1 | Name 1 | 11 | Name 11 | 112 | Name 112 |
1 | Name 1 | 12 | Name 12 | 121 | Name 121 |
1 | Name 1 | 12 | Name 12 | 122 | Name 122 |
2 | Name 2 | 21 | Name 21 | 211 | Name 211 |
2 | Name 2 | 21 | Name 21 | 212 | Name 212 |
2 | Name 2 | 22 | Name 22 | 221 | Name 221 |
2 | Name 2 | 22 | Name 22 | 222 | Name 222 |
You may try adding custom column.
let r = _ in Table.SelectRows(Source, each Text.StartsWith(r[Column1], [Column1]))
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |