Count number of dates between two dates

[shaunguyver]

I have a table with a single column (date), which has a series of dates under it.

I need to create a measure that counts the number of dates that falls in 2018.

Any idea how I can do this?

Thanks

[Vvelarde · Accepted solution]

@shaunguyver

Hi, lets try with this:

Datesin2018 = COUNTROWS(FILTER(Table1,YEAR(Table1[Fecha])=2018))

Regards

Victor

[v-chuncz-msft · Accepted solution]

@shaunguyver,

You may also try the DAX below.

Measure =
CALCULATE ( COUNT ( Table1[date] ), Table1[date].[Year] = 2018 )

[Vvelarde · Accepted solution]

@shaunguyver

Hi, lets try with this:

Datesin2018 = COUNTROWS(FILTER(Table1,YEAR(Table1[Fecha])=2018))

Regards

Victor

[shaunguyver]

This works! Thank you. For some reason I can't accept this as a solution, but please accept this as confirmation that it is - thanks again