The "SAMEPERIODLASTYEAR" function expects a contiguous selection

[matdub40]

I have a measure "Evo%" that allows me to calculate the percentage change in sales between years, the formula is:

Evo %:=
DIVIDE (
[Euro Gross Amount]
- CALCULATE ( [Euro Gross Amount], SAMEPERIODLASTYEAR ( 'date'[date] ) ),
CALCULATE ( [Euro Gross Amount], SAMEPERIODLASTYEAR ( 'date'[date] ) ),
0
)

My date table has continuous values from 2018 to 2022 with no missing days:

When I make my formula it worked perfectly and since yesterday I have as error on my Power BI report:

"Calculation error in measure 'dwh_d_order_sku'[Evo %]: The "SAMEPERIODLASTYEAR" function expects a contiguous selection when the date column comes from a table on side 1 of a bidirectional relationship."

I don't understand where this can come from since my dates are continuous. Can anyone help me with this?

[goncalogeraldes · Accepted solution]

I think that the error is due to the nature of the relationship between your date table and dwh_d_order_sku table being set to bidirectional. Try switching it to single direction from the date table to the dwh_d_order_sku table, that is, from the one to the many side! 

(please note that in this image the cardinality is many to many which is not your case, therefore just focus on the cross filter direction)

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

[matdub40]

Hello @goncalogeraldes,

Thank you for your answer, indeed I had a one to one relationship and in both directions.
I changed to one to many from the date table to dwh_d_order_sku and it works!