Showing results for 
Search instead for 
Did you mean: 
Not applicable

12 Months Rolling Measure total incorrect in table

Hi everyone, 


I am currently facing an issue in DAX Power BI. 


I am trying to display a 12 Months Rolling Measure for customers. However, when displayed in a table with only 1 customer column, I have an issue with the totals displayed. 

I have been trying all kinds of solutions found online and suggestions from colleagues, but I can't seem to find the solution. I might be overthinking the problem and I'm sure an easy fix exists. Enough of me rambling, here is the DAX formula used for the 12 Months Rolling Sales measure : 


12M Rolling Sales= Calculate( SUM([Sales Amount]; DATESBETWEEN('Dates'[Date]; NEXTDAY(SAMEPERIODLASTYEAR( LASTDATE('Dates'[Date]))); LASTDATE('Dates'[Date])))

I've tried using SUMX, Hasonefilter and Hasonevalue and even rebuilding the formula so that it's less complex, but everytime I have the same wrong total. 


Here's a very simplified example of the issue I'm facing : the total row is not correct 

Could anyone help me out ? Thank you very much, I'm really under lot of pressure to get this fixed.


Thank you!


Best regards 




New Member

@Anonymous@Anonymous @po @ATF   Please share solution If this issue solved I am also facing same problem ..

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors