calculate number of rows between two dates

[PierreCA]

Hello, 

I try to code a measure to calculate  a running sum of events on 30 days periods, everyday.  The same date may be present several times in the eventTable. 

For an unknow reason, the program is unable to find a date but has no problem elsewhere in the project. 

I've try many versions of the calculation but failed. 

I have an event table linked to a calendar table. 

Latest version of the code

VAR nbrEvents = CALCULATE (COUNTROWS(EventTable),
	DATESBETWEEN(Calendrar[Date],
	MAX(Calendar[Date])-30,
	MAX(Calendrar[Date])))

Another version

VAR dateFound= SELECTEDVALUE(DISTINCT(eventTable[Date]))

RETURN


CALCULATE(
COUNTROWS(eventTable),FILTER(eventTable, eventTable[date]>= dateFound -30 && eventTable, eventTable[date]<=dateFound))

 
Any clue?

[PierreCA · Accepted solution]

solved.