Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to extract first value from Path function?

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

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
    I solved with PATHITEM(pathcolumn;1)

2 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago
      I solved with PATHITEM(pathcolumn;1)