Forum Discussion
Solved
Modify Value in a Column
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
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
1 Reply
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