Filter a datasource(tableview) using date/time column off of a date, begintime and endtime

Hi JSher ,

Since you have a drillthrough page, you can create a measure like this, put it in the table visual filter of table2 in the target page and set its value as 1:

A =
VAR tab =
    ADDCOLUMNS (
        'Table1',
        "BD",
            CONVERT ( [date] & " " & [BeginDate], DATETIME ),
        "ED",
            CONVERT ( [date] & " " & [EndDate], DATETIME )
    )
VAR bdt =
    MAXX ( tab, [BD] )
VAR edt =
    MAXX ( tab, [ED] )
RETURN
    IF (
        SELECTEDVALUE ( Table2[Date] ) >= bdt
            && SELECTEDVALUE ( Table2[Date] ) <= edt,
        1,
        0
    )

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.