Hello everyone,

I'm currently stuck on a problem where I need to transfer a project to DAX so that I can use Excel's Power Query / Power Pivot functionalities, for example in terms of refresh capabilities.

The goal is to get a visualization of the number of employees at a certain point in a day. (a classic daily curve would describe it perfectly).

I have attached an excel file for better understanding.

Please give me a hint how to write a DAX measure to get the running number of shifts when this particular point of time of a day (daily curve in a chart) is between shift start and shift end.

I hope my explanations are enough to understand me correctly.

Yours sincerely,

Peter