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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Simon_29
Helper II
Helper II

Change the value in a column based on a value in another column

Hello,

in one community I found a command to change the value in one column based on another column, but it doesn't work properly. Could you advise me?

The problem is as follows:
I have an ORDER_STATUS column and a load_date column. I want to change the value in the load_date column based on the value in the ORDER_STATUS column. If the ORDER_STATUS column has the value "CLAW", I want the value "NA: CLAW" to be added to the load_date column.
The function should be correct (I indicated it in the picture), but it does not do what it should.

Can you advise please? Thank you very much.

replace1.png

2 ACCEPTED SOLUTIONS
BA_Pete
Super User
Super User

Hi @Simon_29 ,

 

Change 'Replacer.ReplaceText' in your formula bar to 'Replacer.ReplaceValue'.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

FYI, the reason @BA_Pete's solution works is because Replacer.ReplaceText looks for substrings and Replacer.ReplaceValue looks at the entire contents of a cell.

View solution in original post

3 REPLIES 3
BA_Pete
Super User
Super User

Hi @Simon_29 ,

 

Change 'Replacer.ReplaceText' in your formula bar to 'Replacer.ReplaceValue'.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




I appreciate your advice. Everything is already working. Thank you very much

FYI, the reason @BA_Pete's solution works is because Replacer.ReplaceText looks for substrings and Replacer.ReplaceValue looks at the entire contents of a cell.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors