度量值
Selected date hierarchy =
SWITCH (
TRUE (),
ISFILTERED ( 表[Date].[Day] ), CALCULATE ( [销售金额], DATEADD ( 表[Date], -1, DAY ) ),
ISFILTERED ( 表[Date].[Month] ), CALCULATE ( [销售金额], DATEADD ( 表[Date], -1, MONTH ) ),
ISFILTERED ( 表[Date].[Quarter] ), CALCULATE ( [销售金额], DATEADD ( 表[Date], -1, QUARTER ) ),
CALCULATE ( [销售金额], DATEADD ( 表[Date], -1, YEAR ) )
)
前提是使用“自动日期/时间”功能(Auto Date/Time)并且作为切片器。 |