In between

[varundaftary]

Hello..!!

Using SWITCH function i am trying to find value between the range of annual income. There are 4 conditions - Low, Mid, Average, High.

SWITCH(TRUE(),

income <=100, "Low",

income >=500, "High",

income >= 100 || Income <=300, "Mid"  (how to find this inbetween value)

"AVG"

)

[varundaftary]

Thanks Chris

[tackytechtom]

Hi @varundaftary ,

Does it work with this code?

Measure = 
SWITCH( 
    TRUE(),
    [income] <= 100, "Low",
    [income] >  100  && [income] <= 300, "Mid",
    [income] >  300  && [income] <= 500, "AVG",
    "High"
) 

I might have misunderstood your conditions, but the in between you can with the [income] > 100 && [income] <= 300, "Mid" pattern.

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[ChrisMendoza · Accepted solution]

Is this the expected output?