Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @Simon_29 ,
Change 'Replacer.ReplaceText' in your formula bar to 'Replacer.ReplaceValue'.
Pete
Proud to be a Datanaut!
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.
Hi @Simon_29 ,
Change 'Replacer.ReplaceText' in your formula bar to 'Replacer.ReplaceValue'.
Pete
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.