Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
This is probably a niche use, but has anybody found a way to delimit a column into multiple rows rather than multiple columns using DAX?
Ex:
Keys
1|2|3|4
Into
Keys
1
2
3
4
Yes, you can use the PATHITEM function for that.
you can split by delimiter "|" and to rows in PQ
https://learn.microsoft.com/en-us/power-query/split-columns-delimiter?wt.mc_id=DP-MVP-5004616
Proud to be a Super User!
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |