Last Year Dates Filter on Sales Data


#1

Hello,

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

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.

Regards
Grace


#2

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