TOTALYTD until TODAY

[Anonymous]

Dear all,

I´m trying a "simple" measure to calculate the cumulative values from the beginning of the year until "today".

The formula below works, but notice I´m fixing the "year_end_date"

YTD Values =
TOTALYTD([Total Values];Dates[Dates];ALL(Dates[Dates]);"9/5")

However, if I try to set up "9/5" as a formula, like "TODAY()", or other vars, it gives me an error.

YTD Values =
var Today = MONTH(TODAY()) & "/" & DAY(TODAY())
return
TOTALYTD([Total Values];Dates[Dates];ALL(Dates[Dates]);Today)

Help? 

[OwenAuger · Accepted solution]

@Anonymous

Just clarifying your requirements...

If today is 5-Sep-2017, then what date range do you expect the formula to calculate over?

1. 1-Jan-2017 to 5-Sep-2017 (cumulative total as at today, but with years ending on 31-Dec) 
2. 6-Sep-2016 to 5-Sep-2017 (cumulative total as at today, and with years ending on today's date, which would be the same as summing the last year ending today)
3. Something else?

As a side note, in the TOTALYTD or DATESYTD functions, year_end_date can never be any expression apart from a string literal. If you want a flexible year_end_date, you have to write the time intelligence logic from scratch without using the built-in time intelligence functions.

Owen 🙂