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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Deano478
Regular Visitor

Removing prefixes containing a -

Hi everyone,

 

This is my first post on here and I hope I do this correctly. So im currently hitting a brick wall with something that may sound simple to experienced users.

 

But I have data like so:

PT - No Start
CbCr - In Progress
CT - No Start
PT2 - To be determined 

and so on and what Im trying to do is essentially remove all those prefixes that contain the - so I can get an output in my column like so:

 

No Start

In Progress

No Start

To be determined

 

Many thanks in advance.

1 REPLY 1
Ahmedx
Super User
Super User

pls try this

Screenshot_1.png

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.