随笔分类 -  PowerBI

PowerBI常用笔记（1）-添加日期表
摘要：Date = var firstYear=YEAR(min(SaleByMonth[sale_date_yymmdd])) return ADDCOLUMNS(FILTER(CALENDARAUTO(),YEAR([Date])>=firstYear), "year",DATE(YEAR([Date 阅读全文
posted @ 2021-11-05 09:21 xiaojy 阅读(535) 评论(0) 推荐(0)