topic Re: If value is greater than X return X if value is less than X return X in DAX Commands and Tips

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

AmberJane — Fri, 09 Feb 2024 14:23:39 GMT

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,

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

bhanu_gautam — Fri, 09 Feb 2024 17:27:02 GMT

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

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

AmberJane — Fri, 09 Feb 2024 17:37:12 GMT

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

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

AmberJane — Fri, 09 Feb 2024 18:12:10 GMT

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")