Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Nested If Statement PowerQuery

Hi need help with a  nested if statetment.  I have a table with a Location_code and Unit. Need the follwoing if statement in power query IF the location code is "130" or "600" then replace all the ...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Modified:

     

    if ([Location_Code] = 130 or [Location_Code] = 600) and [Units] = "IPO" then [Units] else if ([Location_Code] = 130 or [Location_Code] = 600) then "Mixed" else [Units]

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

OK add complexity. Forgot to include the logic if Unit equals IPO then Unit. So Location codes that are 130 or 600 and the unit is IPO then UNit else if the Location Code is 130 or 600 then Mixed

Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

Modified:

 

if ([Location_Code] = 130 or [Location_Code] = 600) and [Units] = "IPO" then [Units] else if ([Location_Code] = 130 or [Location_Code] = 600) then "Mixed" else [Units]