Power Query报错：'Address Correction'名称未识别问题求助

问题根源 #

在Table.AddColumn的each表达式中，直接用#"列名"的格式无法正确引用当前行的列值，必须通过[#"列名"]的语法来访问上下文里的行数据。你的代码里所有列引用都缺少了方括号，导致Power Query无法识别这些列。

修正后的M代码 #

= Table.AddColumn(#"Changed Type1", "Call Drivers", each Text.Combine(
    {
        Text.Combine({
            [#"Address Correction"], [#"Delayed Packages"], [#"Package Status"], [#"Package Received In Error"], [#"Reattempt"], [#"Delivery Issue"], [#"Support Ticket"], [#"Return to Sender"], [#"Location"], [#"Label"], [#"Vacation Hold"], [#"Drop Off"], [#"Money Back Guarantee"], [#"Claims"], [#"Hold at Location"], [#"Domestic Claims"], [#"International Claims"], [#"General Inquiry"], [#"International Shipments"], [#"FedEx Delivery Manager"], [#"Other/s"], [#"Call Tag"], [#"Complaints"], [#"Delivery Instructions"]
        }, ","),
        Text.Combine({
            [#"Ground Pickup"], [#"Express Pickup"], [#"Missed Pickup"]
        }, ","),
        Text.Combine({
            [#"Appointment Delivery"], [#"Billing/Invoice Inquiry"], [#"Delivery Issue1"], [#"Disputes Delivery"], [#"LTL Pickup"], [#"Pickup Cancellation"], [#"Pickup Status"], [#"Quote"], [#"Shipment Inquiry"]
        }, ","),
        Text.Combine({
            [#"Express Domestic Pickup"], [#"Express Domestic Pickup Status"], [#"Express Domestic Rating"], [#"Express Domestic Tracking"], [#"Express International Pickup Status"], [#"Express International Tracking"], [#"International Pickup"], [#"International Rating"], [#"International Shipment Inquiry"]
        }, ","),
        Text.Combine({
            [#"Appointment Delivery1"], [#"Shipment"]
        }, ","),
        Text.Combine({
            [#"Invoice"], [#"Rates"]
        }, ","),
        [#"Level 1 Location Call Driver"],
        [#"Level 1 Supplies Call Driver"]
    }, ",")
)

额外提示 #

• 若部分列可能存在空值，建议用Text.From([#"列名"])包裹列引用，避免Text.Combine处理空值时出错
• 确认#"Changed Type1"步骤确实包含所有你引用的列，步骤重命名或数据加载后列丢失也会触发同类报错

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