YTD value not shown if there is no entry in the month

[DLX_Ares_SP]

Hello everyone,

First of all, sorry if this question is recurring, but I have read a lot on the subject, and I am still not able to solve it.

The problem is that when using the YTD function, if there is a month without a new entry, the output is blank instead of being the last value.

You can see here an example in the chart on the right, look at the light yellow category

Here the same but in a table format:

The result is the same regardless of the following two DAX funtions:

Total YTD Hours = TOTALYTD(SUM(RDPE[Hours]),'Calendar'[Date])

Total YTD Hours (2) = CALCULATE(RDPE[Sum of Hours Amount],DATESYTD('Calendar'[Date]))

Thanks in advance

[parry2k]

@DLX_Ares_SP also make sure in the visual you are using month from the calendar table.

[parry2k]

@DLX_Ares_SP you need share pbix file to take a look, remove sensitive information before sharing.

[DLX_Ares_SP]

Hi @parry2k,

Yes, it is.

Even the table has specifically created using the calendar function as follows:

Calendar = CALENDAR(min(RDPE[Date]), max (RDPE[Date]))

[parry2k]

@DLX_Ares_SP did you mark the calendar table as a date table?