Calculate working hours within a date range

Hi Anonymous ,

Create the following measure:

Hours =
CALCULATE (
    SUM ( WorkingHours[working hours] );
    FILTER (
        ALL ( WorkingHours[Date] );
        WorkingHours[Date] >= SELECTEDVALUE ( Periods[From] )
            && WorkingHours[Date] <= SELECTEDVALUE ( Periods[To] )
    )
)

Regards,

MFelix

Hey Anonymous ,

this is a slightly different solution than the one MFelix provided.

Please be aware that my solution also requires a calendar tarble (though it does not have to be related to one of the tables). 

Create this measure:

Working Hours = 
SUMX(
    VALUES(Period)
    ,CALCULATE(
        SUM(Working[working hours]),
        TREATAS(DATESBETWEEN('Calendar'[Date],'Period'[From],'Period'[To]),Working[Date])
    )
)

Regards,
Tom