Categorizing a column of numbers into Large, Medium, Small

[Absalon29]

I have a colum with market size for each company. I want to classify each company based on its size into Large, Medium, Small using its market size. So for medium I want to capture those that are >=$1bn and <=$1bn as Medium. What is the best way of achieving this?

[Icey · Accepted solution]

Hi @Absalon29 ,

Is this problem sloved?

If it is sloved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Anonymous]

Hello-

   The best way is a calculated column.  Right click in your data and click create column.  

Type = if(calculate(sum(dollars))) > 1,000,000,000, "Large","Medium")

[TomMartens]

Hey,

I guess the articles that are linked on this side

https://www.daxpatterns.com/usecases/classification/

will provide what you are looking for.

My first guess, start with static segmentation:

https://www.daxpatterns.com/static-segmentation/

Regards,

Tom