Forum Discussion
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...
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.
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)