P12M_All_in_Share 1:=
VAR d = MAX ( 'Dim_Date_Fact_Share'[Date] ) RETURN d
P12M_DYA_All_in_Share 1:=
VAR YA =
CALCULATE ( [P12M_All_in_Share 1], DATEADD ( 'Dim_Date2'[Date], -1, YEAR ) )
RETURN
ya

==============
大小写的参数同步问题
x=
VAR d1 =
MAX ( 'Dim_Date_Fact_Share'[Date] )
VAR d2 =
MAX ( Dim_Date2[Date] )
VAR b =
IF ( d2 >= d1, d1, d2 ) //如果选择的时间段超过事实表最大日期,就是事实表最大日期
VAR t =
CALCULATE (
[0Normalized_Share 1],
DATESINPERIOD ( 'Dim_Date2'[Date],EOMONTH(b,-1), -3, MONTH ) //eomonth返回上个月月末
)
RETURN
t
CALCULATE (
[x],
DATEADD ( 'Dim_Date2'[Date], -1, YEAR ) ,DATEADD ('Dim_Date_Fact_Share'[Date] , -1, YEAR )
)
两个DATEADD是为了b变量的if参数保持同步往后一年
网友评论