Forum Discussion
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 ...
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
Do you need a new column? Hope you have two column Location_Code and the Units. If you have numbers in units, why do you want to have text in that as "mixed" ?
Yes, it will be a new column and the Unit is text not numbers oringinaly. Example Unit: GRE, ADO, or ADU.
Anonymous
Click on Custom Column and add the following code:if [Location_Code] = 130 or [Location_Code] = 600 then "Mixed" else [Units]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
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]