topic Re: Calculate multiple occurrence over a period within multiple time ranges in DAX Commands and Tips

Calculate multiple occurrence over a period within multiple time ranges

oskarcph — Fri, 03 Feb 2023 15:16:58 GMT

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?

Re: Calculate multiple occurrence over a period within multiple time ranges

FreemanZ — Fri, 03 Feb 2023 15:29:40 GMT

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?

Re: Calculate multiple occurrence over a period within multiple time ranges

oskarcph — Wed, 08 Feb 2023 10:22:04 GMT

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

Re: Calculate multiple occurrence over a period within multiple time ranges

oskarcph — Wed, 01 Mar 2023 13:52:50 GMT

Anyone? 🙂

Re: Calculate multiple occurrence over a period within multiple time ranges

FreemanZ — Wed, 01 Mar 2023 14:48:15 GMT

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.