Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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]))
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)`
@Anonymous
Refer if this can help
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |