Powerbi 列中密钥对转换的powerquery M.Json数组

Powerbi 列中密钥对转换的powerquery M.Json数组,powerbi,powerquery,powerbi-desktop,powerbi-datasource,Powerbi,Powerquery,Powerbi Desktop,Powerbi Datasource,谢谢你的帮助 我试图将一个名为“Tags”的数组转换为一个列列表:CustomerId、CustomerDisplayName、CustomerPath,其中每个列表都包含一个相应的值,作为每个费用的存储 { "periodFrom": "2020-11-09T00:00:00", "periodTo": "2020-12-08T00:00:00", "charges":

谢谢你的帮助

我试图将一个名为“Tags”的数组转换为一个列列表:CustomerId、CustomerDisplayName、CustomerPath,其中每个列表都包含一个相应的值,作为每个费用的存储

{
    "periodFrom": "2020-11-09T00:00:00",
    "periodTo": "2020-12-08T00:00:00",
    "charges": [
        {
            "listPrice": 5.05,
            "netPrice": 5.05,
            "netPriceProrated": 5.05,
            "subTotal": 5.05,
            "currency": "CAD",
            "isBilled": true,
            "isProratable": true,
            "deductions": [],
            "fees": [],
            "invoice": {
                "number": "2822835",
                "date": "2020-11-16T00:00:00",
                "periodFrom": "2020-10-09T00:00:00",
                "periodTo": "2020-11-08T00:00:00"
            },
            "taxes": [
                {
                    "name": "GST",
                    "appliedRate": 5.0
                },
                {
                    "name": "QST",
                    "appliedRate": 9.975
                }
            ],
            "tags": [
                {
                    "name": "CustomerId",
                    "value": "42c8edf4-365a-4068-bde6-33675832afbb"
                },
                {
                    "name": "CustomerDisplayName",
                    "value": "Blue Sky Group"
                },
                {
                    "name": "CustomerPath",
                    "value": "Devmesh Co-Branded/Blue Sky Group"
                }
            ]
        }
    ]
}

这里是我实际上正在编写的实际代码片段

let
    ...
    Response2 = Table.FromRecords( { Response } ),
    #"Expand1" = Table.ExpandListColumn(Response2, "charges"),
    #"Expand2" = Table.ExpandRecordColumn(#"Expand1", "charges", {"productId", "productName", "sku", "chargeId", "chargeName", "chargeType", "periodFrom", "periodTo", "quantity", "listPrice", "netPrice", "netPriceProrated", "subTotal", "currency", "isBilled", "isProratable", "deductions", "fees", "invoice", "taxes", "tags"}, {"charges.productId", "charges.productName", "charges.sku", "charges.chargeId", "charges.chargeName", "charges.chargeType", "charges.periodFrom", "charges.periodTo", "charges.quantity", "charges.listPrice", "charges.netPrice", "charges.netPriceProrated", "charges.subTotal", "charges.currency", "charges.isBilled", "charges.isProratable", "charges.deductions", "charges.fees", "charges.invoice", "charges.taxes", "charges.tags"})
in
    #"Expand2"

为了清楚起见,你能准确地显示出这个例子的最终结果吗?@AlexisOlson我刚刚添加了一个用Excel制作的屏幕截图,谢谢你的帮助。