Forum Discussion
Comparison vs same week last year
All, I finally managed to find a solution here in this link https://forum.enterprisedna.co/t/same-period-last-year-for-fiscal-week-nbr-weeks-in-sales-table-are-non-standard/240/8
What I had to do was to create a measure based on the measure that you all had suggested.
You need to set up a Calendar table (either in Power Query or using DAX functions CALENDAR() or CALENDARAUTO()), link the date fields in a one-to-many relationship from the Calendar table to your data table and then use the Calendar date field for your time intelligence calculations (and for measures, slicers and filters for that matter).
For time intelligence functions to work, you require a set of continuous dates (unique) which obviously must cover the whole range of dates in your data.