Forum Discussion
Flagging Non-consecutive overlapping dates
DallasBaba spinfuzer thank you both for providing brilliant solutions! However, I forgot another key thing for this to work pefectly, I need a dynamic data range parameter so I can only see clashing dates on a specific dates e.g within 3mos, 6mos,etc. I could manually filter in M Query datenow+how many days/months but it will not be dynamic.
I figured this can only be done as a measure?
If you need this to adjust dynamically with something like dates on a pivot table then it needs to be a measure.
it should check the Start Dates per ID per location. If it's within the dates in the slicer, it should only check if it's a clash up to the end of the range. For the example below, without a date parameter, ID 2 will be a clash, but following the date range, it's no clash.
Range based on Start Dates:
Start End
01-Jul 02-AugID Location Start Date End Date Status
1 Scotland 01/07/2025 01/08/2025 No Clash
2 Scotland 02/08/2025 01/11/2025 No Clash
3 Scotland 03/08/2025 20/12/2025 Clash