Sales PY for Non Contiguous date range

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 contiguou...

Gabry
2 years ago
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]))

😉

Forum Discussion

Sales PY for Non Contiguous date range

Related content

Combine contiguous or overlapping date ranges

Cumulative Sales in Two Date Ranges

What is contiguous selection?

Sales range by customer

sales from different dates range