YTD Distinct Count and YTD-YoY% Distinct Count

[Xclipse]

Hi @chabbils, does this post help:

Count Unique Values YTD - New calculation for every year

Hello, I am trying to do a distinct year-to-date count in quicksight calculations. For example for 2022, if a user has used a product every month of the year, the user should only be counted once. I’m using the below formula to get this unique count runningSum( distinct_count( ifelse( {Time Period}=minOver({Time Period}, [advertiserid], PRE_FILTER), advertiserid, NULL )), [{Time Period} ASC], ) While this works, it does not partition by year. For Jan 2023, instead of starting a new …

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena)

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!