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)
)

  

posted @ 2025-07-01 14:42  CrossPython  阅读(12)  评论(0)    收藏  举报