Delimit Column to Multiple Rows Using DAX

[tag25]

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

[lbendlin · Accepted solution]

Yes, you can use the PATHITEM function for that.

Table = DATATABLE("Keys",STRING,{{"1|2|3|4"}})

Table 2 =

var t = max('Table'[Keys])

return ADDCOLUMNS(GENERATESERIES(1,PATHLENGTH(t),1),"Keys",PATHITEM(t,[Value]))

[ryan_mayu]

@tag25 

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