Modify Value in a Column

[utsavlexmark]

Hello,

I am having a table that is getting data from csv files from a sharpoint folder. The value is coming as "XXXX, YYYY, North America". Now I want to eliminate the ",North America" part from the value. How can I do this through query in Power Bi desktop?

Please help me.

Regards

Utsav

[PhilipTreacy · Accepted solution]

Hi @utsavlexmark 

In Power Query (Transform Data) click on the column header then click Replace Values.

In Values to Find enter ,North America and leave Replace With empty.

Click OK

Regards

Phil