Forum Discussion
Solved
Is it possible to have an If function in another If function
Hi
I'm interested in moving this DAX formular into Power Query:
S1 = IF(IF('STATUS 1'[t2s1q4] >2;1;0)+If('STATUS 1'[t2s1q5] >2;1;0)+If('STATUS 1'[t2s1q11] >2;1;0)+If('STATUS 1'[t2s1q12] >2;1;0)+if('STATUS 1'[t2s1q13] >2;1;0)+if('STATUS 1'[t2s1q14] >2;1;0)+if('STATUS 1'[t2s1q15] >2;1;0) >2;TRUE;FALSE)
It is an If function with multiple If functions within it: If(if + if + if ..) then, else - I am using it to measure If different test scores are above a certain limit (>2) and finally If >2 of these tests are above that limit. All the STATUS tables range from 1-5.
Is this possible in Power Query, as it is in DAX?
I'm fairly new to M, so this might be a newbie question. I would appreciate any help!
It is an If function with multiple If functions within it: If(if + if + if ..) then, else - I am using it to measure If different test scores are above a certain limit (>2) and finally If >2 of these tests are above that limit. All the STATUS tables range from 1-5.
Is this possible in Power Query, as it is in DAX?
I'm fairly new to M, so this might be a newbie question. I would appreciate any help!
Please note, you can also use "and" "or". An example of a simple one:-
If
(
[Column1] = "A"
and
[Column2] = "B"
)
then "Confirmed A & B"
else if
"not A&B"
else
"something else"
4 Replies
Hi Thorstedt,
jop, it is possible. Just add a new column in PowerQuery Editor UI and rewrite your many ifs. A documentation for IF can be found here: https://docs.microsoft.com/en-us/powerquery-m/expressions-values-and-let-expression#If
Please note, you can also use "and" "or". An example of a simple one:-
If
(
[Column1] = "A"
and
[Column2] = "B"
)
then "Confirmed A & B"
else if
"not A&B"
else
"something else"
