Rolling 12 Month Average Calculated Column in Date Table?

[joeshu26]

How could I create a calculated column in my 'Date' table which indicates if current row context is within last 365 days of the last date in my fact table?

 

[PentaGalCXO]

I suggest a measure on either DateDim or FactTable:
DateLastFact:=calculate(max(FactTable[TransactionDate]),all(FactTable))

Then a calculated column in DateDim:
Within365Flag=if([date]>[DateLastFact]-365 && [date]<=[DateLastFact],"Y",blank())

I like having [DateLastFact] as a separate measure so it can be surfaced somewhere on the dashboard for the users to know the age of the dataset.

 

[joeshu26]

Thanks PentaGalCXO, I was using the same last date measure in for other measures but wasn't able to get the syntax right for the calculated column! This works great though thank you!