date ranges
1 Topic
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/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 . SudanSolved1.2KViews0likes1Comment