Sales PY for Non Contiguous date range

[dataandme]

Hi,

I was using the below calculation to find the PY Sales Value,
Sales SPLY = Calculate([Sales],SAMEPERIODLASTYEAR('sales'[Sales Date]))
but get the error SAMEPERIODLASTYEAR expects a contiguous selection when the date column is not unique, has gaps or it contains time portions becuase I dont have sales continuously everyday. 

I tried the Dateadd function, but still same issue arises. 

Is there other ways to calculate the PY measure dynamically? 

Thanks

[Rupak_bi]

Please share sample data and desired out put. 

[Gabry · Accepted solution]

Hey @dataandme ,

don't you have a calendar / date table? If not, you should build one, connect it with the fact table with 1:* realationship (from 'Calendar'[Date] to 'Sales'[Sales Date]), then use this calendar table in your calculate, instead of  Calculate([Sales],SAMEPERIODLASTYEAR('sales'[Sales Date]))

it becomes  Calculate([Sales],SAMEPERIODLASTYEAR('Calendar'[Date]))

😉