Forum Discussion

theapengelly's avatar
theapengelly
Frequent Visitor
2 years ago
Solved

Multiple IF statements on PowerBI Desktop

Hey,

 

Trying to create a custom column where it's value is dependent on [ID] and sometimes [Item] to determine a colour.

 

Any clue why the below is not working? I get an error message that the last 'then' is expecting a bracket?

 

= Table.AddColumn(#"Removed Spaces", "Custom", each if [ID] = "A" then "Red" else (if [ID] = "B" then "Red" else (if [ID] = "C" then "Red" else (if [ID] = "D" then "Red" else (if [ID] = "E" then "Blue" else (if [ID] = "F" then "Red" else (if [ID] = "G" then "Red" else (if([ID] = ("H") or [ID] = ("I") or [ID] = ("J") or [ID] = ("K") or [ID] = ("L")) then (if [Item] = "Socks" then "Green" else if([Item] = "Shirt" then "Yellow" else [ID]))))

 

Thank you in advance!

Need Help
  • suparnababu8's avatar
    suparnababu8
    2 years ago

    Hi theapengelly 

     

    = Table.AddColumn(#"Removed Spaces", "Custom", each 
    if [ID] = "A" then "Red" 
    else if [ID] = "B" then "Red" 
    else if [ID] = "C" then "Red" 
    else if [ID] = "D" then "Red" 
    else if [ID] = "E" then "Blue" 
    else if [ID] = "F" then "Red" 
    else if [ID] = "G" then "Red" 
    else if [ID] = "H" or [ID] = "I" or [ID] = "J" or [ID] = "K" or [ID] = "L" then 
        if [Item] = "Socks" then "Green" 
        else if [Item] = "Shirt" then "Yellow" 
        else [ID]
    else null
)

    Based on my understanding, I recreated this query. Pls use it and let me know if it works or not. 

2 Replies

  • suparnababu8's avatar
    suparnababu8
    Icon for Super User rankSuper User
    2 years ago

    Hi theapengelly 

     

    = Table.AddColumn(#"Removed Spaces", "Custom", each 
    if [ID] = "A" then "Red" 
    else if [ID] = "B" then "Red" 
    else if [ID] = "C" then "Red" 
    else if [ID] = "D" then "Red" 
    else if [ID] = "E" then "Blue" 
    else if [ID] = "F" then "Red" 
    else if [ID] = "G" then "Red" 
    else if [ID] = "H" or [ID] = "I" or [ID] = "J" or [ID] = "K" or [ID] = "L" then 
        if [Item] = "Socks" then "Green" 
        else if [Item] = "Shirt" then "Yellow" 
        else [ID]
    else null
)

    Based on my understanding, I recreated this query. Pls use it and let me know if it works or not.