Last Year Dates Filter on Sales Data

DAX DAX Calculations
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:

Capture
Capture.PNG1437×832 44.7 KB

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