Filter result in a count

I have this code that counts the amount of unique rows in in the "Date" column on this table:

COUNT(UNIQUE(peopleRecords[Date]))

 

Is there any way I can filter the results so it only counts the dates that are in this year? 

Thanks

Solved Solved
0 3 91
1 ACCEPTED SOLUTION

 

COUNT(
 SELECT(
  peopleRecords[Date],
  YEAR([Date]) = YEAR(TODAY()),
  TRUE
 )
)

 

View solution in original post

3 REPLIES 3

 

COUNT(
 SELECT(
  peopleRecords[Date],
  YEAR([Date]) = YEAR(TODAY()),
  TRUE
 )
)

 

Thanks, is there a away I can add the UNIQUE() function to this to prevent duplicate dates from being counted?

The third parameter (here set to TRUE) provides that functionality.

TeeSee1_0-1671679740851.png

 

Top Labels in this Space