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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Table relationship to ensure table filters with the date slicer when the dates in table overlap

I have a table `Staff Booking` containing `Start date` and `End Date` for a job. I also have a calculated table filed with

Date Range 2 = CALENDAR(MIN('Staff Booking'[Start Date]), MAX('Staff Booking'[End Date]))

 

jDJrJ


I want to eventually make a relationship between these two table such that:

1) When the date slicer range is defined, the jobs that overlap the slicer are filtered (using the start dat and end date columns)

2) And for the jobs that overlap, if the `start date < min(slicer date)` then `start date` change to `min(slicer date)`

1 REPLY 1

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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