Count OVER Date Hierarchy

[Lisa Kaplan]

My data table has multiple date columns. I need a calculated column to count the number of rows for each year in date 1. I can get it to work for the individual day, but I can't seem to get it to work for other levels in the hierarchy (month/quarter/year). Can someone please help me with the syntax on this

[Kirsten Smith (she/her)]

Can you try something like:

 

Count(Year([Date])) OVER ([Date])

 

to see if it gives you the results you are looking for