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! Go to Solution.
COUNT(
SELECT(
peopleRecords[Date],
YEAR([Date]) = YEAR(TODAY()),
TRUE
)
)
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.
User | Count |
---|---|
36 | |
31 | |
28 | |
23 | |
18 |