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]

     

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
5 years ago

Here it is if you do not want to add an additional column:

= Table.ReplaceValue(#"Changed Type",each [Unit], each if [Location_code] = 130 or [Location_code] = 600 then "Mixed" else [Unit] ,Replacer.ReplaceText, {"Unit"})