获取日期的技巧
2020-08-12 本文已影响0人
BI罗
VAR x1 =
FIRSTDATE ( ALLSELECTED ( 'P1.Flexible Date Range'[Date] ) )
VAR x2 =
LASTDATE ( ALLSELECTED ( 'P1.Flexible Date Range'[Date] ) )
var x1=CALCULATE(MIN('P1.Flexible Date Range'[Date]))
var x2=EOMONTH(CALCULATE(MAX('P1.Flexible Date Range'[Date])),0) 月末
var x1=EOMONTH(CALCULATE(MIN('P1.Flexible Date Range'[Date])),-1)+1 月初1号
