Skip to main content
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

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


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.