Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Filtering date ranges

I have a table of employees with a column for occupancy start date and a column for occupancy end date. If someone gets promoted or moves to a new department, a new row is created with a new start date and end date, and the previous row gets an end date. Thus, people who have been in the company for a while can have multiple rows. If someone is still working at the company in a particular position, there is no end date. Thus, this table provides a history of who was in the company and where at different times.


I want to add a filter where I can select date ranges, and see exactly who is in the company and where. So if I select 01 January until 28 January, I will see everyone who has an occupancy during that period, even if it was only for a day.


How would I do this?


Frequent Visitor

The problem we have is that there can be multiple rows for each person as they move around the organization, while in your solution the start date is when they joined, and end date is when they left.

@jacques_412 , I need to know the start date when they move around and what you want to count. Check this one, I made a few changes and used a distinct count. File attached, multiple records of employees created


Active should be ok with this example. for hire we might have adjust with hire date for a continuous tenure

Super User
Super User

@jacques_412 , Refer if this approach can help

Power BI: HR Analytics - Employees as on Date :


You can refer to the file attached after your signature


Thanks for this. It is not quite what I am looking for. Someone in the comment section of your Youtube video asked the same question a year ago, but there is no answer.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors