Forum Discussion

sahameeda90's avatar
sahameeda90
New Member
9 years ago
Solved

Conditional If and Logical AND

I am using a very simple conditional if and logical AND statement to create a calculated field. It says there are no syntax errors but when I apply the formula it gives this error Expression.E...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi sahameeda90,

     

    All functions in Power Query, whether text, logic or anything else, are case sensitive. You should use if...then...else instead. Here a good article about if function in Power Query for your reference.

     

    In addition, your current formula with IF and logical AND statement should work when you use it to add a calculate column under Modeling tab in Power BI Desktop. :smileyhappy:

     

     

    Regards