Forum Discussion
Solved
Exclude conflicting dates in date difference calculation
Hello everyone! I'm having trouble excluding date values that are between "bigger" intervals. Can someone please help? 🙂 I find it better to explain through an example (will use integer value...
JayJayOliveira , Please find the file where I have created an overlapping flag
You need create an index column or make join only > or <
Try like
future conflict = if(ISBLANK( COUNTX(FILTER(Sheet1, EARLIER([from Date]) >= [from Date] && EARLIER(Sheet1[from Date])<=([to Date]) && [Index] <> EARLIER([Index])),[from Date])),"NoConflict","Conflict")or
future conflict = if(ISBLANK( COUNTX(FILTER(Sheet1, EARLIER([from Date]) > [from Date] && EARLIER(Sheet1[from Date])<([to Date]) ),[from Date])),"NoConflict","Conflict")
JayJayOliveira , Please find the file where I have created an overlapping flag
You need create an index column or make join only > or <
Try like
future conflict = if(ISBLANK( COUNTX(FILTER(Sheet1, EARLIER([from Date]) >= [from Date] && EARLIER(Sheet1[from Date])<=([to Date]) && [Index] <> EARLIER([Index])),[from Date])),"NoConflict","Conflict")or
future conflict = if(ISBLANK( COUNTX(FILTER(Sheet1, EARLIER([from Date]) > [from Date] && EARLIER(Sheet1[from Date])<([to Date]) ),[from Date])),"NoConflict","Conflict")
hey amitchandak ! Thanks for your response, it worked perfectly on many cases.
But on this one specifically we have an issue. Because of a 30 day conflict it is descarding the 2.9 value.
I wonder if we could just discard the 30 day conflict?
JayJayOliveira , Can you share a better data with expected output