Forum Discussion
'SAMEPERIODLASTYEAR' expects a contiguous selection when the date column is not unique
Hello, I am receiving this error, any clue how to fix it? i am new to power bi.
i have also attached the data and power bi file here
thank you
4 Replies
- amitchandakSuper User
Rony21 , I checked out you are not using date table and for time intelligence date table is must having single directional join with your table.
Refer
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4 - AnonymousNot applicable
Could you please provide more informations about this?
What are you trying to achieve? What is the formula you're using when you get the error?
- AnonymousNot applicable
Hi Rony21 ,
You can refer the following links to try to solve your problem:
DATEADD "expects a contiguous selection when the date column is not unique, has gaps..."
Function 'SAMEPERIODLASTYEAR' expects a contiguous selection Issue
If the above ones can't help you, could you please provide which measure you are using the function SAMEPERIODLASTYEAR in and your expected result? As checked your shared file, I can't find any measure with the error... Thank you.
Best Regards
- Vanchy_LiaoAdvocate IV
Although it is an old thread, i find an alternative solution for it. Use PARALLELPERIOD to resolve it.
e.g. CALCULATE(SUM(Fact_Sales'AMOUNT'), PARALLELPERIOD(Dim_MTH[MTH], -12, MONTH))