Forum Discussion

JVal76's avatar
JVal76
New Member
1 year ago
Solved

Slicing Between Multiple Dates

I have a dataset with ServiceStart and a ServiceEnd date columns. I need a date slicer that will include records that would be considered 'active' based on the date selection.   In this exam...
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi JVal76 ,

    You can follow the steps below to get it, please find the details in the attachment.

    1. Create a measure as below

    Flag = 
VAR _clientid =
    SELECTEDVALUE ( 'IntersectData'[ClientID] )
VAR _year =
    SELECTEDVALUE ( 'Dates'[Date].[Year] )
VAR _month =
    SELECTEDVALUE ( 'Dates'[Date].[MonthNo] )
VAR _yearmonth =
    VALUE ( _year & IF ( _month < 10, "0" & _month, _month ) )
VAR _client =
    CALCULATE (
        MAX ( 'IntersectData'[ClientID] ),
        FILTER (
            'IntersectData',
            'IntersectData'[ClientID] = _clientid
                && VALUE ( FORMAT ( 'IntersectData'[ServiceStart], "YYYYMM" ) ) <= _yearmonth
                && VALUE ( FORMAT ( 'IntersectData'[ServiceEnd], "YYYYMM" ) ) >= _month
        )
    )
RETURN
    IF ( NOT ( ISBLANK ( _client ) ), 1 )

    2. Apply a visual-level filter on the table visual

    Best Regards

lbendlin's avatar
lbendlin
Super User
1 year ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523