jasonnj1978pwest
New Member
- Joined
- Oct 18, 2017
- Messages
- 10
Hi All,
I have a single table query containing rows of members identified with a member number and their eff date and end date. There are members in this table with the same member number whose date span on one row overlap wit their date span on another row. I am trying to identify these members whose eligibility dates overlap.
Example:
Row# | Member# | Eff_Date | End_Date
1 012345678 | 1/1/18 | 6/30/18
2 012345678 | 7/1/18 | 12/31/18
3 012345678 | 4/1/18 | 3/31/19
I would like to have a calculated column that would identifying this member in some way as having overlapping dates of eligibility.
And then ideally I would like a DAX formula probably that would identify how many months of overlapping eligibility there are for those members that have overlapping eligibility.
Thank you for your time!
I have a single table query containing rows of members identified with a member number and their eff date and end date. There are members in this table with the same member number whose date span on one row overlap wit their date span on another row. I am trying to identify these members whose eligibility dates overlap.
Example:
Row# | Member# | Eff_Date | End_Date
1 012345678 | 1/1/18 | 6/30/18
2 012345678 | 7/1/18 | 12/31/18
3 012345678 | 4/1/18 | 3/31/19
I would like to have a calculated column that would identifying this member in some way as having overlapping dates of eligibility.
And then ideally I would like a DAX formula probably that would identify how many months of overlapping eligibility there are for those members that have overlapping eligibility.
Thank you for your time!
