Calculate multiple occurrence over a period within multiple time ranges

[oskarcph]

Measure = 
var _sdate = MAX(TableA[Shift_start_date])
var _edate = MAX(TableA[Shift_end_date])
var _count = 
 COUNTROWS(
        FILTER('TableB'[DateTime]>=_sdate && 'TableB'[Datetime]<=_edate))

return
    IF(ISBLANK(_count),0,_count)

Hi Guys

I hope you can help me, I am trying to calcucate number of occurrences on multiple days. 
The above formula is generating the right output if I put it into a table for a daily view but if I wants to calcucate the number of occurrences in a week then it also shows the last output (Which is due to the MAX()), so can you help?

[oskarcph]

Anyone? 🙂 

[FreemanZ]

hi @oskarcph 

when you say "calcucate the number of occurrences in a week ", could you make a screenshot about how the measure will be showcased? what context do you have for the measure?

p.s. please consider @someone, to continue a discussion.

[FreemanZ]

hi @oskarcph 

when you say "calcucate the number of occurrences in a week ", could you make a screenshot about how the measure will be showcased?

[oskarcph]

Hi Freeman, sorry for the late reply 

So, I need to see if a flight leaves during an employee's shift, I made a column with the date and time of the flight's departure to link up with the employees shift which consist of two columns (See picture), a shift can example start at 22:00 monday and end at 06:00 on the next day