YTD Running Totals

[Ashish_Mathur]

Hi,

Does this work?

YTD Total = CALCULATE( [Item Count], DATESBETWEEN( 'Calendar'[CalendarDate], DATE(YEAR(TODAY()),1,1),TODAY()))

[littlemojopuppy · Accepted solution]

No. Same result.  But this works...

YTD Total = 
    TOTALYTD(
        [Item Count],
        'Calendar'[CalendarDate],
        'Calendar'[CalendarDate] <= TODAY()
    )

I'm good.  Overthinking it!  Thank you for your help!

[littlemojopuppy]

Ha!  The underlying problem was really that in my ETL/data shaping, the date table has dates going out to 2024 or 2025 (for accountants forecasting).  I was pulling in "this year" but after playing with this across numerous dashboards I think the TOTALYTD function really pulls up to the last date available in the date table (or source of dates).

Changing the ETL/data shaping process to include only to YTD instead of this year solved all my problems.