TOTALYTD - In table with monthly breakdown - current month / future month not shown correctly

[Fabrizio]

Hi!

This is my first question i am posting here, so i hope i manage to explain my problem: 

I have daily invoiced quantities. I would like to show the quantities in a table, listed by month. 

As measures, i show the monthly quantities and the cumulated quantities (YTD) 

My Problem: If i use YTD, all future Months have the same value filled in (Value as of YTD Today). 

I managed to hide the future months (including current month) like this:

IF(

LASTDATE('Date'[Date]) > TODAY(),

BLANK(),

CALCULATE('Actuals'[Total Actual], DATESYTD('Date'[Date])))

But i would like to see the TOTALYTD including the current month. So for now (Today is 16.03.) - March and the following months are shown blank in my table. But March should show Total YTD until yesterday, April and following should stay empty.

Any Idea how i could solve this? 

Thanks!

[Fabrizio]

Hi johnt75, works perfectly. Thanks for your immediate help!

IF(

LASTDATE('Date'[Date]) > EOMONTH(TODAY(),0),

BLANK(),

CALCULATE('Actuals'[Total Actual], DATESYTD('Date'[Date])))

[johnt75 · Accepted solution]

try changing the LASTDATE line to

LASTDATE( 'Date'[Date] > EOMONTH(TODAY(),0 )