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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
DiePic
Resolver II
Resolver II

Duplicate a column with text replace

Hi all

I have a table that is imported from dynamics 365 sales.
I need to duplicate a column but I must cancel the suffix of the code .... this is the example:
NrOpportunity = "OPP-0001"
NewColumnNrOpportunity = "0001"
....

How can I do that?

1 ACCEPTED SOLUTION
Mikelytics
Resident Rockstar
Resident Rockstar

Hi @DiePic 

 

base data

Mikelytics_0-1674226341626.png

 

Mikelytics_1-1674226386074.png

define delimiter -> you can also use OPP-

Mikelytics_2-1674226414607.png

Results

Mikelytics_3-1674226448076.png

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

 

 

 

 

 

 

 

 

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

View solution in original post

2 REPLIES 2
Mikelytics
Resident Rockstar
Resident Rockstar

Hi @DiePic 

 

base data

Mikelytics_0-1674226341626.png

 

Mikelytics_1-1674226386074.png

define delimiter -> you can also use OPP-

Mikelytics_2-1674226414607.png

Results

Mikelytics_3-1674226448076.png

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

 

 

 

 

 

 

 

 

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

Hi @Mikelytics 
thanks for your help...
that is what I'm searching for my duplicate column ....

DiePic_0-1674227535976.png

 

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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