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
Dino.
