Trim till a specific character in Power BI

[Anonymous]

Hello Experts,

I want to trim a column value till a specificed character (,), which fourmula i should use.

For Example i want to make 

25.276539,55.4582489 to 25.276539

and in another column 

25.276539,55.4582489 to 55.4582489

[HotChilli · Accepted solution]

In Power Query, right-click the column and 'split by delimiter'-> use ',' 

If i understand correctly, you can remove the other column because you've achieved what you want.

[Anonymous]

Thanks @HotChilli , This Is Excatly what i was looking for