Power Query生成ISO周数格式问题：如何转为两位数格式

要将生成的ISO周数转为两位数格式（如01、02），只需在原计算逻辑外层嵌套Text.PadStart和Text.From函数，把数字型周数转换为带前导零的两位文本：

#"Inserted ISO Week Number" = Table.AddColumn(
    #"Inserted End of Week", 
    "ISO Week Number", 
    each 
        Text.PadStart(
            Text.From(
                if Number.RoundDown((Date.DayOfYear([Date])-(Date.DayOfWeek([Date], Day.Monday)+1)+10)/7)=0 then 
                    Number.RoundDown((Date.DayOfYear(#date(Date.Year([Date])-1,12,31))-(Date.DayOfWeek(#date(Date.Year([Date])-1,12,31), Day.Monday)+1)+10)/7) 
                else if (Number.RoundDown((Date.DayOfYear([Date])-(Date.DayOfWeek([Date], Day.Monday)+1)+10)/7)=53 and (Date.DayOfWeek(#date(Date.Year([Date]),12,31), Day.Monday)+1<4)) then 
                    1 
                else 
                    Number.RoundDown((Date.DayOfYear([Date])-(Date.DayOfWeek([Date], Day.Monday)+1)+10)/7)
            ), 
            2, 
            "0"
        )
)

关键说明 #

• Text.From()：把计算得到的数字周数转换为文本类型，为后续填充操作做准备
• Text.PadStart(文本, 2, "0")：将文本长度固定为2位，若原文本是单数字（如"1"），会自动在前面补"0"，变成"01"

内容的提问来源于stack exchange，提问作者ApAMiX