PowerBI常用笔记（1）-添加日期表

Date =

var firstYear=YEAR(min(SaleByMonth[sale_date_yymmdd]))

return

ADDCOLUMNS(FILTER(CALENDARAUTO(),YEAR([Date])>=firstYear),

"year",DATE(YEAR([Date]),12,31),"year_month",EOMONTH([Date],0),"month",FORMAT([Date],"mm"),"month_num",MONTH([Date]))