Forum Discussion

usama7's avatar
usama7
New Member
1 year ago
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 Status]]="Matched"),"Confirmed","Not Confirmed")

 

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

 

 

 

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    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")

     

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    1 year ago

    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")