Forum Discussion
function if and language M
Hello,
does it exist in Language M:
the if + and ?
thanks
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.
4 Replies
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.
NathanielYes they both exist.
If
https://docs.microsoft.com/en-us/dax/if-function-dax
And (which you could use a & or && for depending on situation)
Anonymous ,
I believe he was asking after the M language, not DAX.
Nathaniel
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.
