I have a dataset here that is linked to a date table.
What I want to do is to do a rolling 12 month addition.
So I created a measure
DATESINPERIOD ( DATE_TABLE[Date], LASTDATE ( DATE_TABLE[Date] ), -12, MONTH )
but when I added in the Year, this measure started to work differently than expected. It's likely it is because the year is added, so it filters differently.
Is this possible?