Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Finding a way to split the column

Hello everyone, Morning!   I hope you guys are doing well. Appreciate all your replies   I had a column in Power BI, where the data was not in the same format, and I am looking for splitting th...
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    You just need to add a custom column to your existing query and put this formula in the pop-up box.  Replace Exams with your actual column name.

     

    Text.Combine(List.Select(List.LastN(Text.Split([Exams], "-"),2), each Text.Contains(_, "2")), "-")

     

    Pat

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Pat, 

Morning! 

Thanks pat, it seems to be working - But, how can I change that code to my scenario 

 

could you please ellobrate it. (While I am trying to perform in the same way. 

Added custom column, 

(Paste the code you provided)

from "Table.AddColumn"  then it was creating a new table and while expanding I selected only the new column I required. 

But, few columns were working fine others are wrongly misplaced. 

Thanks pat, 

 

looking forward to hear from you. 

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

You just need to add a custom column to your existing query and put this formula in the pop-up box.  Replace Exams with your actual column name.

 

Text.Combine(List.Select(List.LastN(Text.Split([Exams], "-"),2), each Text.Contains(_, "2")), "-")

 

Pat