cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qa4432 Frequent Visitor
Frequent Visitor

Re: Lab 2 SAMEPERIODLASTYEAR Only works with contiguous date selections

Thank you!!!!  This explanation helped me exponentially and engranged in my head about utilizing the Date Dimension correctly.

bajimmy1983 Member
Member

Re: Lab 2 SAMEPERIODLASTYEAR Only works with contiguous date selections

Hello Community, 

 

Could anyone get back to this post and try to help me? If I understood correctly, my relationship between Date table (as date type for sure) and transactional table is correct... How to fix this error or have some kind of workaround? Maybe I need to learn new functions to resolve. I am a junior in Power BI.

 

Problem persist...

When I select contiguous quarters in Donut chart object (eg: 1st, 2nd or 2nd 3th) it works fine, as desired, but as picture below when I select for example 1st and 4th problem appears. As you know Users always check this kind of thing and I do not want to show errors or any message they cannot understand (and they do not need to).

 

Images:

 

1_Relationship.JPGI think this was set correctly2_Relationship.JPGPlease Help

 

Thanks a lot in advance.

 

Jaderson Almeida
Business Coordinator
bajimmy1983 Member
Member

Re: Lab 2 SAMEPERIODLASTYEAR Only works with contiguous date selections

I forgot to share the Sample File

Jaderson Almeida
Business Coordinator
rizwan_ahmed Frequent Visitor
Frequent Visitor

Re: Lab 2 SAMEPERIODLASTYEAR Only works with contiguous date selections

great !, it worked,  Many thanks

Sumesh Frequent Visitor
Frequent Visitor

Re: Lab 2 SAMEPERIODLASTYEAR Only works with contiguous date selections

Absolutely 100% correct