Convert Excel Formula to to power BI Query Formula

[usama7]

Hello looking to convert my IF formula as below 

=IF(OR([@[Confirmation Status]]="Confirmed",[@[Confirmation Status]]="ManlConfirmed",[@[Confirmation Status]]="autoConfirmed",[@[Confirmation Status]]="Matched"),"Confirmed","Not Confirmed")

I'm Looking to add a Custom Column where I get this where I can enter the fomula

[usama7]

Thanks again!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

if [Confirmation Status] = "Confirmed" or [Confirmation Status] = "ManlConfirmed" or [Confirmation Status] = "autoConfirmed" or [Confirmation Status] = "Matched" then "Confirmed" else "Not confirmed"

= Table.AddColumn(Source, "expected result column", each if [Confirmation Status] = "Confirmed" or [Confirmation Status] = "ManlConfirmed" or [Confirmation Status] = "autoConfirmed" or [Confirmation Status] = "Matched" then "Confirmed" else "Not confirmed")