Lisa Kaplan Posted November 22, 2019 Share Posted November 22, 2019 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 Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted November 25, 2019 Share Posted November 25, 2019 Can you try something like: Count(Year([Date])) OVER ([Date]) to see if it gives you the results you are looking for Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now