LTM revenue calculated with DATESINPERIOD

[tomhav223]

Hi guys, I have a rolling calendar in PowerBI combined wih Transaction data. I have created a measure calculating LTM revenue:

Revenue Netto LTM = CALCULATE([Revenue_Netto],DATESINPERIOD(Dates_Lookup[Date],MAX(Dates_Lookup[Date]),-12,MONTH))

The calculation is not very accurate though and I can't understand why.

I would expect the total to amount to 2022 YTD (484k) plus transactions from November 2021 (682k + 14k). However I only see 2022 total as LTM value. Any idea what am I doing wrong?

Many thanks for any suggestions.

Tomas.