在企业报表中,特别是电商或零售企业最常用的报表是日报,那么怎么设置才能每天打报表时默认状态都是最新的日期呢?
我们先来构建一张日期表,用到的都是些基础的日期函数,就不再过多介绍
Date =
ADDCOLUMNS (
CALENDAR (DATE(2020,1,1), TODAY()-1),
"Year", YEAR ( [Date] ),
"Month", Month ( [Date] ),
"YearMonth", FORMAT ( [Date], "YYYYMM" ),
"DayOfMonth", DAY( [Date] ),
"DayOfWeek", WEEKDAY ( [Date], 2),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"Week", WEEKNUM( [Date] ),
"YearQuarter", FORMAT ( [Date], "YYYY\QQQ" ),
"ISO Week", WEEKNUM( [Date], 21),
"ISO Year", YEAR( [Date] + 26 - WEEKNUM( [Date], 21 ) ),
"Week Start Date", [Date] - WEEKDAY ( [Date], 3 )
)
接下来我们新建三个切片器,分别是年月日,如果我们给切片器设定了值,那默认打开报表就是这个值不会变了,比如现在选择的是2022.5.7,那么明天查看报表还是这个