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,380 points
82 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,380 points

Related Questions In Power BI

+3 votes
1 answer

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
• 32,440 points
17,279 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
• 32,440 points
73 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
• 32,440 points
77 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
• 32,440 points
42 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 22, 2019 in Power BI by VNK
12,205 views
+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,030 points
3,274 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,060 points
149 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 21, 2018 in Power BI by nirvana
• 3,060 points
979 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,030 points
210 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
• 51,830 points
203 views