DIM_日期表 = GENERATE( CALENDARAUTO(), ROW( "年",YEAR([Date]) & "年", "季度",QUARTER([Date]), "季度名称",SWITCH(QUARTER([Date]),1,"一季度",2,"二季度",3,"三季度","四季度"), "月份",MONTH([Date]), "月份名称",MONTH([Date]) & "月", "日",DAY([Date]), "星期",WEEKDAY([Date],2), "星期名称",SWITCH(WEEKDAY([Date],2),1,"星期一",2,"星期二",3,"星期三",4,"星期四",5,"星期五",6,"星期六",7,"星期日"), "周数",WEEKNUM([Date]) ) )
power BI 同比环比代码
销售额月环比 = (
VAR TEMP = CALCULATE([销售额], DATEADD('DIM_日期表'[Date], -1, MONTH))
RETURN DIVIDE([销售额] - TEMP, TEMP)
)