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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

SAMEPERIODLASTYEAR() not adding correctly

Community Support
Community Support

Hi @abyars ,


Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.


Best Regards,

Neeko Tang

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

Frequent Visitor

I have also figured out that the grand total is correct, but after the first subtotal, the subtotals are all incorrect.

Hi @abyars ,


Here are some suggestions:

- Make sure you have a proper date table that is marked as date in the model view and has a one-to-many relationship with your fact table. You can use the CALENDAR() or CALENDARAUTO() functions to create a date table.
- Try using the DATEADD() function instead of SAMEPERIODLASTYEAR() to shift the dates by one year.

- Check if your date column has any gaps or missing values that might affect the calculation of SAMEPERIODLASTYEAR(). You can use the ISBLANK() function to identify any blank values and replace them with appropriate values.
- If you are using a slicer or filter to select a specific time period, make sure it is applied to both the current year and the previous year measures. You can use the ALLSELECTED() function to remove filters from a column while retaining any filters from slicers or other visuals.


In order to better understand your demands and give the right solution, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.


Best Regards,

Neeko Tang

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

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.