Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
I am trying to correct a number value that was entered incorrectly in the database. I am basically using the add custom but not sure why it's not working.
Am I do something incorrectly? Thanks!
Solved! Go to Solution.
Hi @Rsanjuan,
So you want to replace current value based on other columns, right?
If this is a case, you can try to add a custom steps and use below formula:
ReplaceValue= Table.ReplaceValue(#"Changed Type",each [Bid Value V2],each if [Job.Name] = "S0S17800487" then 78570 else [Bid Value V2] ,Replacer.ReplaceValue,{"op_id"})
Sample:
Reference link:
Query editor replacing values based on another column
Regards,
Xiaoxin Sheng
Hi @Rsanjuan,
So you want to replace current value based on other columns, right?
If this is a case, you can try to add a custom steps and use below formula:
ReplaceValue= Table.ReplaceValue(#"Changed Type",each [Bid Value V2],each if [Job.Name] = "S0S17800487" then 78570 else [Bid Value V2] ,Replacer.ReplaceValue,{"op_id"})
Sample:
Reference link:
Query editor replacing values based on another column
Regards,
Xiaoxin Sheng
I don't believe that you can edit the numbers within a column by creating another custom column.
I would do this:
=if [Job.Name]="SOS17800487" then 78570 else [Bid Value v2]
So it would copy all of the values from [Bid Value v2] except when the [Job.Name] is equal to SOS17800487. Then it would use 78570.
Then you can delete [Bid Value v2]
I am assuming that you want 78570 as a numerical value. If you want it as a text value, then you have to place it within quotation marks.
Let me know if this helps!
This may be a dumb question, but where exactly where would I put that? In the edit query mode?
Yep! While editing your query, click "Add Custom Column" and then use that formula and whatever Column Header you would like.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.