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