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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Rsanjuan
Advocate III
Advocate III

Correcting a number value in data

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.

Capture.JPG

 

 

 

Am I do something incorrectly?  Thanks!

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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:

1.PNG2.PNG

 

Reference link:
Query editor replacing values based on another column

 

Regards,

Xiaoxin Sheng

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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:

1.PNG2.PNG

 

Reference link:
Query editor replacing values based on another column

 

Regards,

Xiaoxin Sheng

bdymit
Resolver II
Resolver II

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!

@bdymit

 

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.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors