Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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?

1 ACCEPTED SOLUTION
Mariusz
Community Champion
Community Champion

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

 

View solution in original post

2 REPLIES 2
Mariusz
Community Champion
Community Champion

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
Not applicable

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 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.