Solved: Custom Query IF statement

beccar_13 · ‎08-09-2017

I am trying to write an IF statement in the edit query but am having no luck. Is this function available?

MarcelBeug · ‎08-10-2017

Neither link mentions what happens if you use and's and or's without parentheses, so here is a little teaser for you:

= if 1 < 2 and 1 < 2 or 1 > 2 and 1 > 2 then """or"" starts a new group" else """and"" starts a new group"

Specializing in Power Query Formula Language (M)

Anonymous · ‎08-10-2017

Perhaps you can take a look at following links to know more about if statement:

Regards,

Xiaoxin Sheng

MarcelBeug · ‎08-10-2017

Neither link mentions what happens if you use and's and or's without parentheses, so here is a little teaser for you:

= if 1 < 2 and 1 < 2 or 1 > 2 and 1 > 2 then """or"" starts a new group" else """and"" starts a new group"

Specializing in Power Query Formula Language (M)

callow · ‎08-09-2017

These threads should be able to give you your answer:

blopez11 · ‎08-09-2017

Most definitely, in the Query Editor, you can do things like:

if ( [AMT] = 0 or [AMT] = null ) and [Units] = 0 then 0
else 1

or

if [Code] <> null and [Description] <> null then [Code]&": "&[Description]
else if [Code] <> null then [Code]

Hope this helps,

beccar_13 · ‎08-09-2017

Thank you so much for your help! I really appreciate it!

MarcelBeug · ‎08-09-2017

And bear in mind that Power Query is case sensitive with all keywords in lowercase, so IF won't work,

Specializing in Power Query Formula Language (M)

Custom Query IF statement