Formula to validate two date ranges

[sudanaditya]

Hello All - I have a requirement where we need to write a validation either in DAX or in Power Query for the below scenario.

Clone start date  9/1/2019

Clone End date  9/5/2019

CRP start date - 9/5/2019

CRP End date -10/1/2019

The scenario   is that the conditional colum should populate"Risk" else "no Risk"  if any one of the dates in the  CRP start date and CRP end Date ( Range) fall in betweeen Clone Start - Clone end date ( Range) .

Thanks in advance .

Sudan

[d_gosbell · Accepted solution]

Putting the folling in a calculated column should give you want you want. This logic should cover both full and partial overlaps.

= IF (  [CRP start date] <= [Clone end date] 
  && [CRP end date] >= [Clone start date], "Risk", "No Risk")