MMA DAX

[dr_anas]

Your assistance is required in determining the cause of the discrepancy between Excel sheet calculations and DAX in Power BI.

Using a DAX and a table containing sales figures and calendar dates, I compute the MMA for the previous three and six months. However, as the screenshot demonstrates, there are inconsistencies between the MMA calculation in the Excel file (which contains the original data that I am also utilizing in Power BI) and the visual in my Powr BI dashboard.

I.e: Excell sheet is showing MMA 3 months is 5,400 however in my dashboard is 5,382.

[Ahmedx]

pls try

[dr_anas]

Thanks @Ahmedx however, it fails to function for me.

[Ahmedx]

can you share the file