Split words from one column to two new columns

[Anonymous]

Hi everyone,

I am still learning PowerBi and I am struggling to find the right formula that will allow me to achieve what is below:

First column is what I have and second and third columns are what I want:

OwnedBy_ReviewedBy		OwnedBy		ReviewedBy
Owned By:John, Reviewed By:David		John		David

Your help is greatly appreciated!

Thanks

[Anonymous]

Hi @Anonymous ,

You could follow @Greg_Deckler  to create calculated columns.

Here is my workaround to add custom columns in Power Query:

=Text.BetweenDelimiters([OwnedBy_ReviewedBy],"Owned By:", ", Reviewed")

=Text.AfterDelimiter([OwnedBy_ReviewedBy],"Reviewed By:")

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler · Accepted solution]

@ Try: 

OwnedBy Column =
  VAR __Path = SUBSTITUTE([OwnedBy_ReviewedBy],":","|")
  VAR __Path1 = SUBSTITUTE(__Path,",","|")
RETURN
  PATHITEM(__Path1, 2)

ReviewedBy Column =
  VAR __Path = SUBSTITUTE([OwnedBy_ReviewedBy],":","|")
  VAR __Path1 = SUBSTITUTE(__Path,",","|")
RETURN
  PATHITEM(__Path1, 4)