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)
)
浙公网安备 33010602011771号