PowerBI 去年同一天
VAR CurrentDate = TODAY() VAR LastYear = YEAR(CurrentDate) - 1 VAR CurrentMonth = MONTH(CurrentDate) VAR CurrentDay = DAY(CurrentDate) VAR IsLeapYear = MOD(LastYear, 400) = 0 || (MOD(LastYear, 100) <> 0 && MOD(LastYear, 4) = 0) var m=IF( CurrentMonth = 2 && CurrentDay = 29 && NOT(IsLeapYear), DATE(LastYear, 2, 28), DATE(LastYear, CurrentMonth, CurrentDay) )