Forum Discussion
Solved
Convert Excel Formula to to power BI Query Formula
Hello looking to convert my IF formula as below =IF(OR([@[Confirmation Status]]="Confirmed",[@[Confirmation Status]]="ManlConfirmed",[@[Confirmation Status]]="autoConfirmed",[@[Confirmation Stat...
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")
Thanks again!