Calculate calls from range of hours

[SerenellaWonder]

Hi, i have one column with hours from pbx report and i have 24 hour format from 00:00:00 to 23:59:00. I need to extract only hours from 09:00:00 to 11:00:00 and 11:01:00 to 13:00:00 and 14:30:00 to 17:30:00 and for this range i need to calculate the ID calls in ID column...this report is the count of calls for hours range...

[v-juanli-msft · Accepted solution]

Hi @SerenellaWonder 

Create a table, then create a measure

Measure =
CALCULATE (
    COUNT ( Sheet1[id] ),
    FILTER (
        ALL ( Sheet1 ),
        MAX ( 'Table'[period start] ) <= Sheet1[Time.1]
            && MAX ( 'Table'[period end] ) >= Sheet1[Time.1]
    )
)

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