Start Time and End Time slicers

Power BI
1

Hi,
I am trying to create a slicer(s) for the user to select a start time and end time .
Based on the selections - I want to be able to use all the time entries between the two values for my various calculations.
I have 2 unrelated time tables for the Start Time and End Time and another time table.
I am not sure how to relate the 3 tables to achieve what I am after.
I attached the pbix file for reference.

Thanks,
Dana

Enterpise DNA Sample.pbix (1.1 MB)

2

@Dana

First I marked the Date as Date Table and then changed the Time columns to Data Type Time as previously it was set as Text.

Then the following measure did the trick

Measure =
VAR StartTime =
    MIN ( 'start time'[Time Interval 15m] )
VAR EndTime =
    MAX ( 'end time'[Time Interval 15m] )
VAR Result =
    CALCULATE (
        SUM ( Data[count] ),
        FILTER (
            ALL ( 'time'[Time Interval 15m] ),
            'time'[Time Interval 15m] >= StartTime
                && 'time'[Time Interval 15m] <= EndTime
        )
    )
RETURN
    Result

Attaching the PBIX file for your reference.

Enterpise DNA Sample.pbix (1.1 MB)

Thanks.

3 Likes
3

@MudassirAli - thank you so much for your help.

1 Like