Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Nested IF to create a column

I am trying to create a column using nested if statements but I get the following syntax error.   the original formula I want to replicate is:   =IFS(U11<2;"0-2";U11<4;"2-4";U11<6;"4-6";U11<8;"6-...
  • PattemManohar's avatar
    PattemManohar
    8 years ago

    Try using "Conditional Column" option in Power Query Editor. It should easily this.

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
8 years ago

Try using "Conditional Column" option in Power Query Editor. It should easily this.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for the quick response. This solved my problem. PattemManohar I tried using the FORMAT but still got an error. Have you tried it? Thanks

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Anonymous
    I couldn't replicate your error, so I assumed FORMAT may help if for some reason your string is not considred text by PowerBI
    this code works for me:

    Column = IF([Comp Scrap]<= 2, "0 - 2",
    IF([Comp Scrap] > 2 && [Comp Scrap] <=4, "2 - 4",
        BLANK()
    ))