Forum Discussion
Flagging Non-consecutive overlapping dates
Hello! I hope you guys could help me in solving this, I need to flag rows that have clashing date ranges against the rest of the dates for a specific location. In this example, I am subtracting cur...
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-Aug
ID 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