Filter Start Time

Hi @pamboys09 ,

Please check following steps as below:

1. Create calculated table as slicer:

Table 2 = CALENDARAUTO()

2. Create measure:

Measure =

VAR td =

    FORMAT ( SELECTEDVALUE ( 'Table 2'[Date] ), "YYYYMMDD" ) & 20

VAR pd =

    FORMAT ( PREVIOUSDAY ( 'Table 2'[Date] ), "YYYYMMDD" ) & 21

RETURN

    CALCULATE (

        SUM ( 'Table'[# of Cases] ),

        FILTER (

            'Table',

            FORMAT ( 'Table'[Time Stamp], "YYYYMMDDHH" ) >= pd

                && FORMAT ( 'Table'[Time Stamp], "YYYYMMDDHH" ) <= td

        )

    )

3. Result would be shown as below:

BTW, Pbix as attached, hopefully works for you.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.