topic Re: Sales PY for Non Contiguous date range in DAX Commands and Tips

Sales PY for Non Contiguous date range

dataandme — Tue, 03 Sep 2024 05:50:31 GMT

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

Re: Sales PY for Non Contiguous date range

Gabry — Tue, 03 Sep 2024 07:13:05 GMT

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]))

😉

Re: Sales PY for Non Contiguous date range

Rupak_bi — Tue, 03 Sep 2024 07:17:02 GMT

Please share sample data and desired out put.