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 in Power BI by ch
• 3,290 points
16 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 by anonymous
• 3,290 points

Related Questions In Power BI

+1 vote
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 in Power BI by Cherukuri
• 31,840 points
6,984 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 in Power BI by Cherukuri
• 31,840 points
31 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 in Power BI by Cherukuri
• 31,840 points
45 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 in Power BI by anonymous
• 31,840 points
27 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 in Power BI by VNK
8,996 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
• 16,300 points
2,319 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
106 views
0 votes
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
753 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
• 16,300 points
139 views
0 votes
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
• 42,330 points
137 views