Forum Discussion

Fabrizio's avatar
Fabrizio
Regular Visitor
4 years ago
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.   ...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    try changing the LASTDATE line to

    LASTDATE( 'Date'[Date] > EOMONTH(TODAY(),0 )
Fabrizio's avatar
Fabrizio
Regular Visitor
4 years ago

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

 

 

IF(
LASTDATE('Date'[Date]) > EOMONTH(TODAY(),0),
BLANK(),
CALCULATE('Actuals'[Total Actual], DATESYTD('Date'[Date])))