Forum Discussion
Solved
Power Query IF and AND Statement with Multiple Conditions
Good evening, I am still new to Power Query and haven’t created many custom formulas. Below is an Excel formula I need assistance recreating in Power Query. This formula is used to determine...
Hi aliciab425 ,
I'm not going to completely rewrite the formula, but here is the structure and terminology you need to do this in Power Query:
if [AST Terr 1] = "BLANK1" and [AST Terr 2] = "BLANK2" and [AST Terr 3] = "BLANK3" then "investigate" else if [AST Terr 1] = [AST Terr 2] and [AST Terr 1] = [AST Terr 3] then [AST Terr 1] else if [AST Terr 1] <> "BLANK1" and [AST Terr 2] = "BLANK2" and [AST Terr 3] = "BLANK3" then [AST Terr 1] else if... ... else //your escape value here e.g. null, "ERROR" etc.Any logical operators (+, *, <, > etc.) can be used in exactly the same way as in Excel.
Pete
Hi aliciab425 ,
I'm not going to completely rewrite the formula, but here is the structure and terminology you need to do this in Power Query:
if [AST Terr 1] = "BLANK1" and [AST Terr 2] = "BLANK2" and [AST Terr 3] = "BLANK3" then "investigate"
else if [AST Terr 1] = [AST Terr 2] and [AST Terr 1] = [AST Terr 3] then [AST Terr 1]
else if [AST Terr 1] <> "BLANK1" and [AST Terr 2] = "BLANK2" and [AST Terr 3] = "BLANK3" then [AST Terr 1]
else if...
...
else //your escape value here e.g. null, "ERROR" etc.
Any logical operators (+, *, <, > etc.) can be used in exactly the same way as in Excel.
Pete