Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
103991
Frequent Visitor

Date filter

Hello,

 

I'm having the following problem. I have a couple of sales tables relating to a date table as well as a persons table. 

 

Now, i'm adding a table to define the teams for each person. The problem i have is that people have been in different teams and can switch in the future, but everyone is doing the same activities. I have the startdate and enddate for each person for when they where in the same team. I need a date filter for the results of each team on an individual level, team level and department level (all teams). 

 

In an ideal world i would like it to connect to my date table, but i haven't been able to work that out. 

 

Example: Person x is working in a team A from the 1st of Januari - 1st of Februari. Then switches to team B from the 1st of Februari - 1st of March. When i set a date filter from the 1st of Janari - 1st of March and select team A. I only need the results of person X from the 1st of Januari - 1st of Februari.

 

Any suggestions?

1 ACCEPTED SOLUTION
1 REPLY 1

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.