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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Michaelbean21
Advocate II
Advocate II

SAMEPERIODLASTYEAR function no longer working

Has anyone else experienced the SAMEPERIODLASTYEAR function as of the July 2023 PowerBi update no longer functioning in their report?

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @Michaelbean21 

 

I have tested it and it works. The DAX Guider you can refer. 

SAMEPERIODLASTYEAR function (DAX) - DAX | Microsoft Docs

 

Or you can try the equivalent formula:DATEADD(dates, -1, year)

Pbix in the end you can refer.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-zhangti
Community Support
Community Support

Hi, @Michaelbean21 

 

I have tested it and it works. The DAX Guider you can refer. 

SAMEPERIODLASTYEAR function (DAX) - DAX | Microsoft Docs

 

Or you can try the equivalent formula:DATEADD(dates, -1, year)

Pbix in the end you can refer.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler
Super User
Super User

@Michaelbean21 You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

 

I'll have to test whether there is some kind of bug or issue with SAMEPERIODLASTYEAR. 

 

You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Idrissshatila
Super User
Super User

Hello @Michaelbean21 ,

 

did you try to use Previous year function ?

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




This function is also not working for me.  I have had the SAMEPERIODLASTYEAR measure working for over 6 months now and all of a sudden it started returning null values in my report.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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