If value is greater than X return X if value is less than X return X

[AmberJane]

Good Morning, 

I have a column that comes over with location numbers. I need to find a way to transform this column to show if the value is greater than 1000 return "1000+ Stores" if value is less than 1000 return "1-999 Stores" 

Thank you, 

[bhanu_gautam · Accepted solution]

@AmberJane , You can achieve it using Switch function

Store Classification =
SWITCH (
TRUE (),
'YourTableName'[Location Number] > 1000, "1000+ Stores",
'YourTableName'[Location Number] <= 1000, "1-999 Stores"
)

Please accept as solution and give kudos if it helps

[AmberJane]

Very cool that did work but I missed something. If stores are 0 I need a third option of 0 locations impacted. How would I add that?

So need: 

1000+ Stores 

1-999 Stores 

0 Stores 

[AmberJane]

This worked.. although I am not sure its the best way to do it haha.

Stores Impacted = SWITCH(TRUE(),'YourTableName'[Location Number] >= 1000, "1000+ Stores", 'YourTableName'[Location Number]  > 1, "1-999 Stores",'YourTableName'[Location Number]  = 0, "0 Stores")