Total Sales YTD for non-standard date table

[Melissa]

Hi @Nurry90,

@Greg has put together a great article with pretty much all you need to know in regard to this topic, it also covers calculating totals - you can find that here.

Non-Standard Time Intelligence

The available DAX date intelligence functions in Power BI handle the comparison with previous periods easily for the standard periods of year, quarter, month, and day when using a standard calendar, or a standard fiscal calendar (where quarters start on a 3-month cadence, e.g., April 1, July 1, etc., and aligned to [but offset from] calendar quarters). These functions do not, however, handle weekly comparisons or custom fiscal calendars. Calculation techniques to handle week comparisons and non-…

.
If you need further assistance please provide a sample PBIX