Categorize employees

[Anonymous]

Hi,

I have a table with a lot of consultants, but I want to create a new column (created with DAX) where I categorize them based on how long they have been employed. So if the consultant has been employed for 1 month, then he is "Insertion 1m" and 2-3 months, he is "Insertion 2-3m".
I think IF statement is the solution, but I am not sure. Can anyone help?

[Mariusz · Accepted solution]

HI @Anonymous 

You can try switch, like below.

Column = 
VAR _months = DATEDIFF( 'YourTable'[Started ], TODAY(), MONTH )
RETURN 
SWITCH(
    TRUE(),
    _months = 0, "new starter",
    _months = 1, "1 month",
    _months IN { 2, 3 }, "2 to 3 months",
    "Over 3 months"
) 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

Hey @Mariusz 

That worked perfectly. But I have another problem.  I want the choice options you wrote, but I also want some new options in my column which are determined by another column (not based on date). So in that same switch statement, I want to refer to another column 🙂 

Thanks