IF & AND formula in power query?

[Anonymous]

Hi I'm using power query and I would like to use IF & AND statement for the below formula that I had in Excel.

The formula i used in excel to achieve the results is : IF(AND($A2="UK",LEFT($B2,3)="IE0"),$C2*0.86,$C2).

The images here show the sample data as well as the intended results.  

Sample dataIntended results

[Icey]

Hi @Anonymous ,

Please let us know if the expression @AlB provided is helpful.

If it is, please accept his reply as solution to your question so that people who may have the same question can get the solution directly.

If not, please give us more details.

Best Regards,

Icey

[AlB · Accepted solution]

Hi @Anonymous 

Add a custom column with this code, calling it "Result Actual" (or whatever other name you want):

if [Country]="UK" and Test.Start([Profit Centre], 3) = "IE0" then  [Actuals]*0.86 else [Actuals] 

You can then remove the original Actuals column

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers