Forum Discussion

ronaldbalza2023

Icon for Continued Contributor rank

Continued Contributor

4 years ago

Solved

Sameperiodlastyear - error

Hi everyone, how can I manage to overcome this error? Thanks! Data Model Relationship

Tips and Tricks

V-lianl-msft
4 years ago
I wonder if you are using non contiguous calendar tables to cause this issue.

It may also be the issue of FilterDirection. For specific discussion, you can refer to this thread to see if it is helpful to you:

https://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Lab-2-SAMEPERIODLASTYEAR-Only-works-with-contiguous-date/td-p/15404

Icon for Super User rank

Super User

4 years ago

Hi,

Check the box of "Make this relationship active" (second screenshot of your message).

ronaldbalza2023
Continued Contributor
4 years ago
Ashish_Mathur hi, thanks for taking the time on this. Unfortunately, I am getting the same error. Thanks!
- Ashish_Mathur
  Super User
  4 years ago
  Hi,
  
  Share the link from where i can download your PBI file.