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...
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?