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.
Hi, I'm connected to an SQL Database, doing some data cleaning (translations), and I'm not sure why the Replace Value is not responding. Am I missing something? Screenshot below:
Thank you,
Ovidiu
Solved! Go to Solution.
Hi @OvidiuNeacsu ,
Try changing the M code in the formula bar from 'Replacer.ReplaceText' to 'Replacer.ReplaceValue'.
If this doesn't work, then you can just add a new custom column using the same logic from your replace code.
Pete
Proud to be a Datanaut!
Yes, the Replacer.ReplaceValue did it. Thank you!
Is ReplaceValue a standard for any format?
I normally use the Replace Values menu to get the formula set up and then I add the conditions... but it always says Replacer.ReplaceText
I'm not 100% sure on the mechanics behind to be honest but, at first glance, ReplaceText should theoretically have worked as you were only dealing with pure text values (not integer, boolean, special etc.). The only thing I can think it might be is that the cells you were trying to replace started as nulls and therefore not text, but wouldn't stake my house on this.
As a general rule of thumb with replacing values, if one doesn't work, the other will 🙂
Pete
Proud to be a Datanaut!
Hi @OvidiuNeacsu ,
Try changing the M code in the formula bar from 'Replacer.ReplaceText' to 'Replacer.ReplaceValue'.
If this doesn't work, then you can just add a new custom column using the same logic from your replace code.
Pete
Proud to be a Datanaut!
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.