Forum Discussion
Creating Measures for distinct count between 2 custom dates
I have a dataset of leads with unique IDs and lead dates for the past 2 years. However, the years are not based on the calendar year, but a custom time frame 8/1 - 7/31. I also created a date table...
Thank you this was helpful, especially the date table set up. However I am still running into an issue because I am not using the SUM function on numbers, I am actually counting records on the dataset.
| CONTACT_ID | Lead Date |
| abcd | 08/15/19 |
| efgh | 06/28/20 |
| ijkl | 08/15/20 |
| mnop | 04/01/2 |
In this case I am trying to count distinct IDs on current year (8/1/2020 - 7/31/2021),previous year, and previous year to date.
My expected outcome would be -
Current Year - 2
Previous Year - 2
Previous YTD - 1
Thanks for your help