IF statement for banding numbers

Hi Anonymous,

Try:

if [NumberOfUsers] <250 then "SME" else if [NumberOfUsers] >=250 and [NumberOfUsers]<1000 then "Corporate" else if [NumberOfUsers] >=1000 and [NumberOfUsers]<5000 then "Enterprise" else if [NumberOfUsers] >=5000 then "Global" else "null"

Br,

T

Anonymous

Some clarification:

In Query Editor you can use my previous code and in DAX you can use Thejeswar code.

Br,

T