Forum Discussion
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-...
Try using "Conditional Column" option in Power Query Editor. It should easily this.
in DAX you can try wrapping the text in FORMAT function .e.g
FORMAT("0 - 2","")