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

Hi DataP 

try new calculated columns

Split column 1 = LEFT([Calculcated column], SEARCH("-", [Calculcated column]) - 1 )
Split column 2 = MID([Calculcated column], LEN([Split column 1]) + 2, LEN([Calculcated column]) - SEARCH("-", [Calculcated column], LEN([Split column 1]) + 2 ) )
Split column 3 = RIGHT([Calculcated column], LEN([Calculcated column]) - LEN([Split column 1]) - LEN([Split column 2]) -2)