Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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
    7 years ago

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

prakash11440278's avatar
prakash11440278
Post Prodigy
7 years ago

Try to create new custom column in Query Editor, like below.

 

(IF([COMP SCRAP]<=2) THEN "0-2" ELSE
IF([Comp Scrap]>2 AND [Comp Scrap]<=4) THEN "3-4" 

ELSE "")

 

(IF (U11<2) THEN "0-2" ELSE
IF(U11<4) THEN "2-4" ELSE
IF(U11<6) THEN "4-6" ELSE
IF(U11<8) THEN "6-8" ELSE
IF(U11<=10) THEN "8-10" ELSE
IF(U11>10) THEN ">10" ELSE "")