Forum Discussion

DataP's avatar
DataP
New Member
6 years ago
Solved

Split a calculated column

Hello,  I am trying to split a calculated column but I haven't been able to find how. I was planning to use the "split column" option built on PowerBi but once I went to "Transform data" my calculat...
Need Help
  • az38's avatar
    az38
    6 years ago

    DataP 

    or (and thats much better):

    Split column 1 = PATHITEM(SUBSTITUTE([Calculcated column], "-", "|"), 1)
Split column 2 = PATHITEM(SUBSTITUTE([Calculcated column], "-", "|"), 2)
Split column 3 = PATHITEM(SUBSTITUTE([Calculcated column], "-", "|"), 3)
az38's avatar
az38
Community Champion
6 years ago

DataP 

or (and thats much better):

Split column 1 = PATHITEM(SUBSTITUTE([Calculcated column], "-", "|"), 1)
Split column 2 = PATHITEM(SUBSTITUTE([Calculcated column], "-", "|"), 2)
Split column 3 = PATHITEM(SUBSTITUTE([Calculcated column], "-", "|"), 3)
DataP's avatar
DataP
New Member
6 years ago

az38 

This is a beautiful solution and worked great for me. Thank you!