Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
dataandme
Frequent Visitor

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

1 ACCEPTED SOLUTION
Gabry
Super User
Super User

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

 

😉

View solution in original post

2 REPLIES 2
Rupak_bi
Super User
Super User

Please share sample data and desired out put. 



Regards
Rupak
FOLLOW ME : https://www.linkedin.com/in/rupaksar/
Gabry
Super User
Super User

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

 

😉

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.