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
I'm interested in moving this DAX formular into Power Query:
Solved! Go to Solution.
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"
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
Hi @Nolock
Thanks, I figured out the different formulation: If((if [a] >x THEN y ELSE z)+(If [b] >x THEN y ELSE z) .... ) >x THEN "True" ELSE "False")
Thanks!
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"
That might be a simpler solution than my first attempt. Thanks!
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.