Forum Discussion

dataandme's avatar
dataandme
Frequent Visitor
2 years ago
Solved

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's avatar
    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]))

     

    😉

Gabry's avatar
Gabry
Icon for Super User rankSuper User
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]))

 

😉