Forum Discussion

sudanaditya's avatar
sudanaditya
Regular Visitor
6 years ago
Solved

Formula to validate two date ranges

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/...
date ranges
  • d_gosbell's avatar
    d_gosbell
    6 years ago

    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")

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago

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")