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

Sample Code that may help your case from Microsofts documentation.  It also depends if your using DAX or Power Query as the coding is completely different.

DAX:

Price Group = IF( 'Product'[List Price] < 500, "Low", IF( 'Product'[List Price] < 1500, "Medium", "High" ) )

IF function (DAX) - DAX | Microsoft Docs