Last Year Dates Filter on Sales Data


I have a non-standard calendar, which looks like following:

My sales data is joined with calendar through 1st column. This is how my data model looks like:

I am having trouble with calculating last year figures. If I can’t do Sales[SalesDate] = Calendar[LastYearSalesYear], because calendar is joined with CurrentDate and not LastYear Dates.

How do i go about this ? Is there a way I can filter sales data based on LastYearDate.

Thanks for any help.


Highly recommend adjusting your data model shape to look more like a waterfall. I cover this is detail in the below module

To work out this use the techniques cover below. You need to use a combination of CALCULATE and the FILTER function. It’s not too difficult