Count Unique Values YTD - New calculation for every year

[Max]

Hi @Madura_Puri

I’m still a little unclear on the ask.

Have you looked into this post specifically on YTD calculations?

Creating period comparisons with QuickSight's periodOver and periodTo functions

Hi, @Steph. Thanks for the followup. The purpose of the periodOverPeriodLastValue calculation was to create a symmetrical runningSum comparison month-over-month-over-month, said another way comparing the same number of days in each period. In your example, taking it one step further by having another runningSum column for the prior month and month offset. Therefore, on a visual, you would have three lines, showing the runningSum up to a specific day (the 8th for each respective month for example…