Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Categorize employees

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?

Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    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.
    Mariusz Repczynski

     

2 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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.
    Mariusz Repczynski

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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