Hello @cms418,
Since I ran out of characters/word space here’s the additional or important points mentioned below pertaining to the solution provided above -
Important Notes:
1). In the case of blank end date, the start date itself is considered as a end date. You can modify the logic as per your business scenario/requirements.
2). Wherever Start Date or End Date of the previous criteria and the End Date of the new criteria is same in that case they’re still considered as over-lapping in my measure logic.
3). The entire measure is of more than 600+ lines so if you’re not comfortable with the long measure then in that case you can also break the variables into small individual measures for your understanding purposes. I’ve already placed the comments above each variable which will help you to break-out the measure for analyzing purposes.
4). As per your business logic, you got to add/less or modify the “IF()” conditions inside each variable as per your business scenario’s, if required. The solution already does the heavy lifting since all criteria’s of the dates are considered in this measure now. So if you’ve any additional requirements pertaining to it then modify the logic or conditions as per your requirements.
5). The solution is checked at each and every step based on the logic considerd inside the measure and therefore in case of additional logic please make the changes accordingly as per your business scenario.
Thanks and Warm Regards,
Harsh