I have the obvious relationships in my power pivot data model. I have 2 tables....Sales and Dates
DimDate[DateKey] --> Sales[Orderdate]
I want to calculate sales for the following specific dates and slice them by years.
Jan-1st to Jan-1st is called NewYearSales,