Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Proud to be a Super User!
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |