Forum Discussion
Solved
if statement in M language and Query Editor
Hi all, I'd like to use an if statement in the power bi query editor to choose what lines of m-language code to execute based on a certain variable: For example: if myVariable = 0 then...
Yes, you're already there: Just add some let-expressions. This is the pattern:
let myVariable = 1, Result = if myVariable = 1 then let DoSth = "DoSth", DoSthElse = "myVariable is 1" in DoSthElse else let ElseDoSth = "Here is my else", Else2DoSth = "Here is my other else" in Else2DoSth in Result
Yes, you're already there: Just add some let-expressions. This is the pattern:
let
myVariable = 1,
Result = if myVariable = 1
then let
DoSth = "DoSth",
DoSthElse = "myVariable is 1"
in
DoSthElse
else let
ElseDoSth = "Here is my else",
Else2DoSth = "Here is my other else"
in
Else2DoSth
in
Result