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

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

Based on my test, mahoneypat 's method should work in your scenario.

 

 

In addition, you can also try this:

 

 

 

Best Regards,

Icey

 

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