Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors