Count rows on or before a specific row in terms of time

[mtrotter]

Hello people,

I need to create a new table from a table called DASHBOARD PANEL:
Imported Column 1: "id" of service

Imported Column 2: "F.Pres" Presentation Date of service

Imported Column 3: "H.Pres" Presentation Time of service

Calculated Column 4: Services between 8:00 AM and the presentation time of the row on the same presentation date

For example, for day 12/07/2022:

id	F.Pres	H.Pres	Services Between 8 AM and H.Pres
486255	12/07/2022	8:00:00	6
481058	12/07/2022	8:00:00	6
484068	12/07/2022	8:00:00	6
480908	12/07/2022	8:00:00	6
476811	12/07/2022	8:00:00	6
484034	12/07/2022	8:00:00	6
476808	12/07/2022	8:00:00	6
485247	12/07/2022	8:30:00	11
485248	12/07/2022	8:30:00	11
486356	12/07/2022	8:30:00	11
484553	12/07/2022	8:30:00	11
484611	12/07/2022	8:30:00	11
478481	12/07/2022	8:30:00	11
484070	12/07/2022	9:00:00	14
484609	12/07/2022	9:00:00	14
484071	12/07/2022	10:00:00	17
486515	12/07/2022	10:00:00	17
484032	12/07/2022	10:00:00	17
486257	12/07/2022	11:00:00	22
481057	12/07/2022	11:00:00	22
484079	12/07/2022	11:00:00	22
484606	12/07/2022	11:00:00	22
483900	12/07/2022	11:00:00	22
484072	12/07/2022	12:00:00	27
484033	12/07/2022	12:00:00	27
476814	12/07/2022	12:00:00	27
480896	12/07/2022	12:00:00	27
476820	12/07/2022	12:00:00	27
485725	12/07/2022	13:00:00	28
486261	12/07/2022	14:00:00	29
483901	12/07/2022	22:00:00	30
482147	12/07/2022	23:00:00	31
484813	12/07/2022	23:59:00	32

Does anybody know how to do this?

[mtrotter · Accepted solution]

I ended up making a column instead of a table, this worked:

Services between 8:00 and presentation  =

=

VAR Fecha_Fila_Actual = 'DASHBOARD PANEL'[F.Pres]

VAR Hora_Presentacion = 'DASHBOARD PANEL'[H.Pres]

RETURN

CALCULATE(DISTINCTCOUNT('DASHBOARD PANEL'[id]),

    ALLEXCEPT('DASHBOARD PANEL','DASHBOARD PANEL'[F.Pres]),

    'DASHBOARD PANEL'[F.Pres] = Fecha_Fila_Actual,

    'DASHBOARD PANEL'[Tipo SS] = "LOCAL SCL",

     DASHBOARD[Estado] = "FINALIZADO",

    'DASHBOARD PANEL'[H.Pres] <= Hora_Presentacion,

    'DASHBOARD PANEL'[H.Pres] >= TIME(8,0,0)

)-1