You can create a calculated column in Calendar Dimension: SameDayLY= var TodayDate = TODAY() var LastYear = YEAR(TodayDate)-1 var LastMonth = MONTH(TodayDate) var LastDay = DAY(TodayDate) return ‘Calendar'[Date]= DATE(LastYear,LastMonth,LastDay) This solution shoule be good for most of the situation. However, your way returned a true value for “2019-03-01” if Today date was a Leap day Read More