Issue with TOTALYTD and Calendar Table

[Shaishavm]

Hi,

Recently I am facing an error using TotalYTD() function.

My calendar table date is defined as CALENDAR("01-01-2015","12-31-2021"). TOTALYTD returns correct value.

If I change my Calenader date to CALENDAR("01-01-2015","03-31-2022"), TOTALYTD doesn't return a value.

Appreciate your help.

TIA,

Shaishav Merchant

[v-robertq-msft]

Hi,

Unfortunately, I can’t reproduce the same issue as yours after my test.

This is my test DAX formula and screenshots:

TOTALYTD = TOTALYTD(SUM('Table'[Amount]),'Date'[Date],ALL('Date'[Date]),"1/1")

I think you should check the DAX formula you used and the original table data to make sure there’s no problem first.

More info about the TOTALYTD function in DAX

Best Regards,

Community Support Team _Robert Qin

[Shaishavm]

@v-robertq-msft Thanks for your reply.

This is a bit puzzling, sharing below measure dax and screenshots.

My measure is;

YTDSales = totalytd(Posted_Sales_Invoice_Header[InvoiceAmt],CalendarTable[Date])

Calendar("01-01-2015","31-12-2021")

Calendar("01-01-2015","31-12-2022")

I am not sure, what is wrong here.

TIA

Shaishav

[v-robertq-msft]

Hi, 

According to your sample picture, I think you should also check if the relationship between the Posted_Sales_Invoice_Header and your CalendarTable still exists after your update of the DAX formula. Because it can also be one of the potential reasons for this.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[Shaishavm]

@v-robertq-msft thanks again for your reply. Relationship exists between these tables.

The issue is only when I change end date of the calendar.