Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Dom87326
Helper II
Helper II

SAMEPERIODLASTYEAR with empty last year dates

Hello, 

 

I'm having a problem with SAMEPERIODLASTYEAR, when the data is not fully loaded it seems to show wrong cumulative amount. 

 

Is there any other way rather than setting page level filter on filter pane to exclude current year month's from dax formula that doesn't have last year's comparison?

DAX: 
Sameperiodlastyear = CALCUALTE ( [Total Sales], SAMEPERIODLASTYEAR ( DimDate [Date] ) )

 

Many thanks in advance!

PBI3.PNG

 



1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @Dom87326 ,

 

can you show which filter contexts are affecting the visual by hovering over the small filter icon like that:

selimovd_0-1629383708346.png

 

For me it looks like there is a filter from October on and that's the reason the visuals shows only 7'664 instead of 37'516. Same for the total.

As an alternative, would it be possible to share the file? Then I can take a look.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

1 REPLY 1
selimovd
Super User
Super User

Hey @Dom87326 ,

 

can you show which filter contexts are affecting the visual by hovering over the small filter icon like that:

selimovd_0-1629383708346.png

 

For me it looks like there is a filter from October on and that's the reason the visuals shows only 7'664 instead of 37'516. Same for the total.

As an alternative, would it be possible to share the file? Then I can take a look.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.