Forum Discussion
Solved
TOTALYTD - In table with monthly breakdown - current month / future month not shown correctly
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!
try changing the LASTDATE line to
LASTDATE( 'Date'[Date] > EOMONTH(TODAY(),0 )
