Forum Discussion
Custom Query IF statement
I am trying to write an IF statement in the edit query but am having no luck. Is this function available?
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"
6 Replies
These threads should be able to give you your answer:
https://community.powerbi.com/t5/Desktop/IF-Statement-Custom-Column/m-p/125631/highlight/true#M53204
Most definitely, in the Query Editor, you can do things like:
if ( [AMT] = 0 or [AMT] = null ) and [Units] = 0 then 0
else 1or
if [Code] <> null and [Description] <> null then [Code]&": "&[Description]
else if [Code] <> null then [Code]Hope this helps,
Thank you so much for your help! I really appreciate it!
HI beccar_13,
Perhaps you can take a look at following links to know more about if statement:
The IF Function In Power Query
Regards,
Xiaoxin Sheng
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"
