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

Highlighted
Sumesh Frequent Visitor
Frequent Visitor

Re: Lab 2 SAMEPERIODLASTYEAR Only works with contiguous date selections

Absolutely 100% correct

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 70 members 1,194 guests
Please welcome our newest community members: