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

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
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

sahameeda90's avatar
sahameeda90
New Member
9 years ago

THank you v-ljerr-msft.  They work with lower case and a little change with syntax. I appreciate your help.