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)
DataP's avatar
DataP
New Member
6 years ago

Hi mjc543, 

Thank you for your answer, I tried that but the issue I have is that my calculated column does not apppear in the query editor or "transform data". I believe the column on your screenshot is not a calculated column. 

This is why I can't find a way to split my column.

 

 

mjc543's avatar
mjc543
Advocate II
6 years ago

Oh ok I misunderstood, my fault. Question: if it is in fact a "calculated" column - it must have been calculated from something, no? So logically the individual components already exist somewhere? Perhaps they got removed as an applied step in Power Query? If so, delete that step and they will be restored and there will be no need to split.