split column by "|" NOT in Power Bi Query

Hi Mtaberna ,

Try this(it has got the DAX codes) :

http://sqljason.com/2013/06/split-delimited-row-into-multiple-rows.html 

Hi  Mtaberna ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
VAR Temp =
    ADDCOLUMNS ( 'Table', "@Parent", SUBSTITUTE ( 'Table'[1-PATH col], "|", "|" ) )
VAR NewColumns =
    ADDCOLUMNS (
        Temp,
        "@FirstLevel", TRIM ( PATHITEM ( [@Parent], 1, TEXT ) ),
        "@SecondLevel", TRIM ( PATHITEM ( [@Parent], 2, TEXT ) ),
        "@ThirdLevel", TRIM ( PATHITEM ( [@Parent], 3, TEXT ) ),
        "@FourthLevel", TRIM ( PATHITEM ( [@Parent], 4, TEXT ) )
    )
VAR Result =
    SELECTCOLUMNS (
        NewColumns,
        "Original", [1-PATH col],
        "First Level", [@FirstLevel],
        "Second Level", [@SecondLevel],
        "Third Level", [@ThirdLevel],
        "Fourth Level", [@FourthLevel]
    )
RETURN
    Result

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hi Mtaberna ,

Refer these solutions:
https://community.powerbi.com/t5/Desktop/DAX-How-to-Split-left-a-text-column-on-Character-space/m-p/44584#:~:text=You%20can%20simple%20select%20the,will%20create%20two%20new%20columns. 

https://community.powerbi.com/t5/Power-Query/How-to-split-column-till-delimiter-using-DAX/td-p/863563