Function 'SAMEPERIODLASTYEAR' expects a contiguous selection Issue

[Anonymous]

Hello,

I have a problem using SAMEPERIODLASTYEAR function to calculate the sales YTD.

Here is my setup:

- I have a databable with date called FACT[InvoiceDate]. Format is date.

- I created a calendar table (Date = CALENDAR (DATE(2016,1,1), today())) with date and year column. Format is date.

- The Dates table has a 1-many relationship with the FACT[InvoiceDate] column.

- I am using below formula to measure YTD:

• Total Sales = SUM(FACT[Sales])
• Total Sales YTD = TOTALYTD(FACT[Total Sales],DATESYTD('Date'[Date]))
• Total Sales YTD Last Year = CALCULATE(FACT[Total Sales],SAMEPERIODLASTYEAR('Date'[Date]))

It works if my relationship between date table and FACT table are both ways but I get "Function 'SAMEPERIODLASTYEAR' expects a contiguous selection" if I filter on a specific shop.

Then I changed to single relationship and the result for the previous year is wrong: Total Sales YTD Last Year gives me the total sales for 2017 instead of same period.

I went through many post related to this topic but cannot find the solution.

Any help is appreciated, thanks in advance.