Forum Discussion

theapengelly's avatar
theapengelly
Frequent Visitor
1 year 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 ...
Need Help
  • suparnababu8's avatar
    suparnababu8
    1 year 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. 

suparnababu8's avatar
suparnababu8
Super User
1 year 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.