Accrued by identifier and reset the account by month

[Syndicate_Admin]

I need to accumulate "Hours" from the Detail table and reset by months.

I've created the month column based on the date and sorted by Date from lowest to highest

Mes = MONTH([Fecha])

I have used the following measure:

Acumulado = 
CALCULATE(
	SUM('Detalle'[Horas]),
	FILTER(
		ALLSELECTED('Detalle'[identificador]),
		ISONORAFTER('Detalle'[identificador], MAX('Detalle'[identificador]), DESC)
	)
)

It accumulates well, but I don't know how to indicate that I reset the accumulated when I changed the month.

[Syndicate_Admin · Accepted solution]

I've solved it as follows:

Acumulado  = 
CALCULATE (
    SUM ( 'Detalle'[Horas] ),
    FILTER (
        ALLSELECTED ( 'Detalle' ),
        'Detalle'[identificador] <= MAX ( 'Detalle'[identificador] )
             && 'Detalle'[Mes] = MAX ( 'Detalle'[Mes]
    )
))