Powerbi--DAX生成日期表

Calender =
VAR dates=CALENDAR(date(2021,6,1),date(2022,5,31)) #日期的起止时间，本例起：2021-6-1，止：2022-5-31
VAR fystart = 6 #财年的开始月
return
ADDCOLUMNS(dates, #ADDCOLUMNS，增加列函数，依据上边的变量dates
"年", YEAR([Date]),
"月", MONTH([Date]),
"月份", MONTH([Date])&"月",
"日", DAY([Date]),
"季度", ROUNDUP(MONTH([Date])/3,0), #roundup月的编码除以3，1_{3除以3为零点几到1，生成1，4}6除以3为一点几到2，生成2
"周", WEEKNUM([Date]),
"星期几", WEEKDAY([Date],2),
"年季度", YEAR([Date])&ROUNDUP(MONTH([Date])/3,0)&"季度",
"年月", YEAR([Date])100+MONTH([Date]),
"年周", YEAR([Date])100+WEEKNUM([Date]),
"财年", IF(MONTH([Date])<fystart,YEAR([Date]), YEAR([Date])+1),
"财月", IF(MONTH([Date])<fystart, MONTH([Date])+7,MONTH([Date])-5),
"财季", "Q"&IF(MONTH([Date])<fystart, roundup((MONTH([Date])+7)/3,0),roundup((MONTH([Date])-5)/3,0)),
"财年月", IF(MONTH([Date])<fystart,YEAR([Date]),YEAR([Date])+1)*100+IF(MONTH([Date])<fystart,MONTH([Date])+7,MONTH([Date])-5)
)