DATEADD + FIRSTDATE
2020-10-25 本文已影响0人
BI罗
a=
VAR a =
DATEADD ( FIRSTDATE ( dim_date2[Date] ), -1, YEAR )
VAR b =
DATEADD ( LASTDATE ( dim_date2[Date] ), -1, YEAR )
RETURN
CALCULATE (
SUM ( V_Fact_Order_Gtin1[trade_cnt] ),
DATESBETWEEN ( dim_date2[Date], a, b )
)
