Find all employees working/being fired on each date

[Maria9292]

Hi!

I have a data set Employee_Name , Start_Date, End_Date and I need to create a dashboard where I could choose a day, month, or year and see who was an active employee whiting chosen perion, who was fired. 

Would you please hepl me with the logic here?

Thank you!

Maria

[Anonymous]

Hi @Maria 

Create a date table = calendar(min(start_date),max(end_date)

Dont connect these tables.

Drag this to x-axis and create = calculate(distinctcoumt(ID),filter(table,start date<=max(date)&&end_date>max(date)

You will get a measure which will show you active emoloyees on each day.

Post this you would see active employees on each dte.

[Maria9292]

@Anonymous 

Thank you! That gives me a number of employees on each date, but what I need is names. 

I need to be able to filter a list of emloyees when choosing a certain date.

[Anonymous · Accepted solution]

okay got it.

For this include all details from the table and pull it directly in the table visual. Once you click on any part of the above cretae visualization it will filter the results for you.