Custom date filter

Hi jostnachs 

Use a disconnected dates table and create this measure:

Client by Time Period = 
VAR StartDate =
    MIN ( Dates[Date] )
VAR EndDate =
    MAX ( Dates[Date] )
RETURN
    COUNTROWS (
        FILTER (
            Client,
            Client[EffectiveDate] <= EndDate
                && Client[ExpirationDate] >= StartDate
        )
    )

This will return more than 1 only in the dates when the expiraiton and effective dates overlap

Please see the attached pbix for details.

Note: moving forward, please use a sample that we can easily copy paste as table to excel and not an image.