Filtering by Date

samanthabowdell — Mon, 21 Jun 2021 19:48:25 GMT

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.

Re: Filtering by Date

amitchandak — Tue, 22 Jun 2021 03:03:58 GMT

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