Forum Discussion

Irwin's avatar
Irwin
Icon for Helper IV rankHelper IV
4 years ago
Solved

If with multiple values // changing data to 0,1 or 2

Hi Guys,   I would like to create a new coloum where I change my data to three values. Either 0 (=Blanks) or 1 (=everything between 0-100) or 2 (=everything above 100).   I have tried if statemen...
Need Help
  • jppv20's avatar
    jppv20
    4 years ago

    Hi Irwin ,

     

    Try creating a calculated column like this:

     

    IF('Table'[Column]=BLANK(),0,
    IF('Table'[Column]<101,1,
    IF('Table'[Column]>100,"2",
    BLANK())))
     
    Jori
     
    If I answered your question, please mark it as a solution to help other members find it more quickly.

    Connect on Linkedin

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Irwin  Nested IF is difficult to manage, try SWITCH

Column = SWITCH(TRUE(), <condition1>, <Result1>,
                        <condition2>, <Result2>,<Result3>)
Irwin's avatar
Irwin
Icon for Helper IV rankHelper IV
4 years ago

Hi thanks for your reply. Unfortunately I couldt get a switch to work. It said something like it didnt understand "ranges". So it would work for blank values, but not for everything in between 0-100 or 100<