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.