Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Yes 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
Proud to be a Super User!
@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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.