Powerbi-矩阵日期表&矩阵列数据表头排序

最新推荐文章于 2025-03-27 17:48:42 发布

原创最新推荐文章于 2025-03-27 17:48:42 发布 · 2k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#powerbi #矩阵 #excel

本文详细介绍了如何在PowerBI中使用DAX创建包含年、季、月等字段的日期表，并处理行表头的错序问题，通过调整排序实现正确的显示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

首先做一个DAX日期表，Powerbi中新建表输入如下代码即可

日期表 = 

VAR YearStart = 2023    //起始年度
VAR YearEnd = 2024      //结束年度

VAR WeekNumberType = 2
VAR WeekDayType = 2

RETURN
GENERATE (
    CALENDAR( DATE( YearStart , 1 , 1 ) , DATE( YearEnd , 12 , 31 ) ),
    // CALENDAR( DATE( YearStart , 1 , 1 ) , TODAY() ),
    VAR Year = YEAR ( [Date] )
    VAR Month = MONTH ( [Date] )
    VAR Quarter = QUARTER( [Date] )
    VAR Day = DAY( [Date] )
    VAR Weekday = WEEKDAY( [Date] , WeekDayType )
    VAR Week_num = WEEKNUM([Date],WeekNumberType)
    VAR Week_start = FORMAT([Date]-Weekday+1,"YYYY-MM-DD")
    VAR Week_end = FORMAT([Date]-Weekday+7,"YYYY-MM-DD")
    RETURN ROW (
        "年" , Year ,
        "季" , Quarter ,
        "月" , Month ,
        "日" , Day ,
        "周",Weekday,
        "周数",Week_num,
        "星期",RIGHT(FORMAT([Date],"AAA"),1)
    )
)