How to extract first value from Path function?

[Anonymous]

I'm using path and I'm getting value "123 | 456 | 678" to Path Column. I would like to create new column, which included first value of Path which is "123". Is this possible?

https://docs.microsoft.com/en-us/dax/path-function-dax

[az38]

hi @Anonymous 

you've got two option:

1. split by delimiter in the Power Query Editor mode

2. create a calculated column

Column = left([Path Column];(find("|";[Path Column])-1))

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[Anonymous · Accepted solution]

I solved with PATHITEM(pathcolumn;1)