Year to date empty values

[Janoshz]

Hello,

I have a cumulative value and it is compared in a line chart by Year to date and Past year to date. I'd like that YTD did not show the values that are in the future. 

My DAX measure is

YearToDate = CALCULATE([MEASURE1], DATESYTD('Calendar'[Date]), ALLEXCEPT('Calendar', 'Calendar'[Year]))

Thanks guys 🙂

[andhiii079845]

Perhaps this help?:
YearToDate = CALCULATE([MEASURE1], DATESYTD('Calendar'[Date]), FILTER(ALLEXCEPT('Calendar', 'Calendar'[Year]),('Calendar'[Date]<TODAY()))

[Janoshz · Accepted solution]

Ah, well. I got it on my own 🙂

YearToDate = CALCULATE([MEASURE1, DATESYTD('Calendar'[Date]), FILTER(ALL('Calendar'[Date]), 'Calendar'[Date] <=MAX('Accomplishment'[ReportingDate])))