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)
mjc543's avatar
mjc543
Advocate II
6 years ago

Single-click the heading of the column you'd like to split, then click the drop-down labeled 'Split Column' in the 'Transform' group on the 'Home' tab.

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.

 

 

  • 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!

  • 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.