SWITCH statement in DAX using a "between this value and this value" as a filter?

[heathernicole]

VERY new to DAX - I think my issue is I haven't nailed down how to ask the right question yet - which hinders research for an answer:

Trying to create an IF (or a Switch) statement

If "this value" in column is BETWEEN 9999 AND 24999 THEN, (2000)

I've already tried writing it using greater than or equal to 10,000 and less than or equal to 24,999 - that didn't work. 

I've looked at several switch statement examples but they all use a "If this value = "this" set up and I'm looking for a range.

Any pointers or sites that be helpful in figuring out the proper syntax?

THANKS!

[asocorro · Accepted solution]

The SWITCH statement allows comparisons with constants only.  You need to use an IF statement.  For a calculated column, this is an example:

Pop Classification =
IF(Population[Pop] >= 1000 && Population[Pop] <= 25000,
1,
IF(Population[Pop] >= 25001 && Population[Pop] <= 50000,
2,
0)
)

[asocorro · Accepted solution]

I copied exactly what you posted and it worked for me.  Make sure your data is of type Decimal and not Text.

[heathernicole · Accepted solution]

Figured it out... or at least partially... it's summarizing data when it shouldn't so it's adding it somewhere.

So all of your suggestions have helped! 🙂 Thank you!!