cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Anonymous
Not applicable

How remove the unwanted letters in a column.

Hello, 

How can I remove the unwanted letters in the category column below?
I want to remove the PV from each row. 
Thanks!

ROG_BI22_0-1649344391998.png

 

1 ACCEPTED SOLUTION
Whitewater100
Solution Sage
Solution Sage

Hi:

You can do this a couple of ways I know. Here is a calc column:

New Cat = REPLACE(Data1[Category],21,2,"")
Whitewater100_0-1649347488201.png

You can also do in Power Query with ADDCOLUNM > Column by examples and type in first two and computer will catch on and fix all of them.

Hope this helps!

View solution in original post

4 REPLIES 4
Whitewater100
Solution Sage
Solution Sage

Here is Power Query fix:

Whitewater100_1-1649347695892.png

 

Whitewater100
Solution Sage
Solution Sage

Hi:

You can do this a couple of ways I know. Here is a calc column:

New Cat = REPLACE(Data1[Category],21,2,"")
Whitewater100_0-1649347488201.png

You can also do in Power Query with ADDCOLUNM > Column by examples and type in first two and computer will catch on and fix all of them.

Hope this helps!

Anonymous
Not applicable

HEY @Whitewater100  Thanks! It was really helpful. 

Great! Thank you..

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors