Power BI创建日期表的几种方式概览

日环比 用这个

日期表 =

ADDCOLUMNS (
CALENDAR (DATE(2020,1,1), DATE(2020,8,31)),
“年度”, YEAR ( [Date] ),
“季度”, “Q” & FORMAT ( [Date], “Q” ),
“月份”, FORMAT ( [Date], “MM” ),
“日”,FORMAT ( [Date], “DD” ),
“年度季度”, FORMAT ( [Date], “YYYY” ) & “Q” & FORMAT ( [Date], “Q” ),
“年度月份”, FORMAT ( [Date], “YYYY/MM” ),
“星期几”, WEEKDAY ( [Date],2 )
)

动态条形图 用这个

表 = GENERATE (
CALENDARAUTO(),
VAR currentDay = [Date]
VAR year = YEAR ( currentDay )
VAR quarter = “Q” & FORMAT ( currentDay, “Q” )
VAR month = FORMAT ( currentDay, “MM” )
VAR day = DAY( currentDay )
VAR weekid = WEEKDAY ( currentDay,2)
RETURN ROW (
“年度”, year ,
“季度”,quarter,
“月份”, month,
“日”, day,
“年度季度”, year&quarter,
“年度月份”, year&month,
“星期几”, weekid
)
)

https://mp.weixin.qq.com/s/A46jjVXwN4NMUkjDoVnqfQ