Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Re: YTD Running Totals



Does this work?


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

Ashish Mathur

Re: YTD Running Totals

No. Same result.  But this works...

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

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

View solution in original post


Re: YTD Running Totals

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.

Helpful resources

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,423)