Limiting the date range for counting or summing

[Phil Price]

I have a cross-table that shows the number of certain event types that occure in any given month. There is 20 years of data recorded. Event types are rows and months are columns.

The agregation method is Count(). The issue is that it is aggregating across the entire 20 years of data. I can correct this by setting a filter on the data range of interest. What I would like to know is, is there a way to limit a date range using an expression.

I know this is not correct. But something like:

if([incidentDate]) > Year(2019,12,31) Count([incidentID)

Many thanks.

[Phil Price]

Ok, I figured it out.

Count(case when [incidentDate]>=Date(2020,2,1) then 1 END) as [12m Run],