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

4 Replies

V-lianl-msft
Community Support
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
Ashish_Mathur
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.