I'm trying to write an IF statement in Power Query but I want to concatenate the result of the IF statement with something else but am running into trouble. I have,
So basically the result should be either
1-Column2Value or
0-Column2Value
but instead I get either
1 or
0-Column2Value
It's only readying the concatenation part on "else"
I tried wrapping the IF in parenthesis but it doesn't work
How do I tell Power Query that my IF statement is complete?
Code:
if [ColumnTest"] = "No" then "1" else "0" & "-" & [Column2]
So basically the result should be either
1-Column2Value or
0-Column2Value
but instead I get either
1 or
0-Column2Value
It's only readying the concatenation part on "else"
I tried wrapping the IF in parenthesis but it doesn't work
Code:
if ( [ColumnTest"] = "No" then "1" else "0" ) & "-" & [Column2]
How do I tell Power Query that my IF statement is complete?