Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

function if and language M

Hello,   does it exist in Language M: the if + and ?   thanks
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    If +else if + then should be the same as if and. You can create a Conditional column in power query by adding multi rules to check the M code.

     

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous ,

Yes it does! What I will usually do, is use the Add Conditional Column and enter something close, and then look at the syntax in the formula window.  Combine that with google M language and what ever connectors I am researching.

 

Operators Try this for operators.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel