Filtering by Date

[samanthabowdell]

Good evening,

I have a table with the following fields,

Type A Employee - this shows a 1 if they fit that category.

Start Date - the date the employee started with our company

I need to count the number of Type A employees and then filter this by the number of employees working for the company on various dates.

I have another table in the model that shows what status each employees time sheets are at.

The final view needs to show the week commencing, number of Type A employees, and the status from the other table.

I have been going round in circles and would appreciate any help. Thank you.

[amitchandak]

@samanthabowdell ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

See if this offer help in between

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...