454 Calendar and To Date measures

[smic11]

Hi all,

I have the following excel file which describes the calendar used for my analysis:

I just have the Fiscal Year 19 so no other Years are taken in consideration. First day of the year 27th May, Sunday. We follow a 454 calendar.

I need to build Quarter to date, Season to date and Year to date measures. Can someone please help me out?

I've been trying with some other posts on the forum but actually nothing was helping or working for me.

Thank you so much!!

Sara

[v-yuezhe-msft]

@smic11,

Please share sample data of your table following the guide in this thread and post expected result here.

When you calculate year to date measure, you can use DAX below.

YearToDate=TOTALYTD(SUM(table[column]),DATE[Date],"year_end_date")

Regards,
Lydia