Split Column in PowerBi

Question

I have been stuck in splitting column in PowerBi. The below picture is the example of the data I would need to split.

In the qualification tab, I would want to seperate those details along with the dates to separate columns.

Do you think you can help me?

Answer 1

You don't show what you want for a result. In particular you don't show if you want to retain the surrounding parentheses.

If you do want to retain them, then merely split on the transition by inserting this M-Code in the Advanced Editor in the place where you want to do the split.

let
    Source = Excel.CurrentWorkbook(){[Name="Table14"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Qualifications", type text}}),

//split on transition from " " to "("
    #"Split Column by Character Transition" = Table.SplitColumn(#"Changed Type", "Qualifications", 
      Splitter.SplitTextByCharacterTransition((c) => c <> "(", {"("}), {"Qualifications", "Date"}),

//remove trailing " " from first column
    #"Trimmed Text" = Table.TransformColumns(#"Split Column by Character Transition",{{"Qualifications", Text.Trim, type text}})
in
    #"Trimmed Text"

If you want to remove the parentheses, then just split on the "(" and remove the trailing ")"