Home Forums Power Pivot Identifying overlapping date spans

This topic contains 0 replies, has 1 voice, and was last updated by  jasonnj1978 1 month, 1 week ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #17993

    jasonnj1978
    Participant
    • Started: 1
    • Replies: 0
    • Total: 1

    Hi All,

    I have a single table loaded up in power 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 with 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 identify these members in some way as having overlapping dates of eligibility.

    And then ideally I would like a DAX formula that would identify how many months of overlapping eligibility there are for those members that have overlapping eligibility.

    Thank you for your time!

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.