Replace field values if matched

0 votes
How to replace field value if a condition is met, code == "200" then change the existing value +100 to field values.

I have a list of transactions made by users to book slots, but due to some error, the amount for a few transactions changed, so I want to replace or update those values.
Oct 31, 2019 in Power BI by ch
• 3,450 points
184 views

1 answer to this question.

0 votes
Create a custom column in Power Query Editor. Use this column instead of actual column for calculations.

if [Code] == 200 then [Sales] else [sales]+100.

I hope this works!
answered Oct 31, 2019 by anonymous
• 3,450 points

Related Questions In Power BI

+3 votes
3 answers

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 33,010 points
76,678 views
0 votes
1 answer

Combining field values to create an additional field?

Hi Nithin, 1. Go to Power Query Editor, ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 33,010 points
414 views
0 votes
1 answer

Chart with only some values in field in a graph in power BI?

Hi Banu, While creating a chart, put the ...READ MORE

answered Apr 10, 2019 in Power BI by Cherukuri
• 33,010 points
243 views
0 votes
1 answer

Give constant values to a column or field

Hi Priyanka, You can use a measure to ...READ MORE

answered May 17, 2019 in Power BI by anonymous
• 33,010 points
489 views
0 votes
1 answer

Slicer with conditions - if value selected,select related values

I assume that both tables are unrelated ...READ MORE

answered Nov 12, 2020 in Power BI by Gitika
• 65,970 points
692 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered May 23, 2019 in Power BI by VNK
17,078 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,150 points
410 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,150 points
1,615 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,570 points
538 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,370 points
593 views