Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to 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]))
😉
Please share sample data and desired out put.
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]))
😉
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |