Power BI : Columnas sin pivotar

Hola @sahildoshi

Puede agregar una columna personalizada como a continuación (paso de columna agregada), pero no creo que funcione en el modo de consulta directa.

¿A qué origen de datos se está conectando, ya que la mayoría de las veces Unpivot no funcionaría en el modo de consulta directa?

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTIw1AciIwMjAyDH0MAASsFJUygJUqoUGwsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Loan ID" = _t, #"Due Date" = _t, #"Principal Amt" = _t, #"NI Amount" = _t, #"AI Amount" = _t, #"Principal Reverse Amt" = _t, #"NI Reverse Amt" = _t, #"AI Reverse Amt" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Loan ID", Int64.Type}, {"Due Date", type date}, {"Principal Amt", Int64.Type}, {"NI Amount", Int64.Type}, {"AI Amount", Int64.Type}, {"Principal Reverse Amt", Int64.Type}, {"NI Reverse Amt", Int64.Type}, {"AI Reverse Amt", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each 
        #table( 
            type table [#"Component"=text, #"Amount"=number, #"Reverse Component"=text, #"Reverse Amount"=number],
            {
                { "Principal Amt", [Principal Amt], "Principal Reverse Amt", [Principal Reverse Amt] },
                { "NI Amount", [NI Amount], "NI Reverse Amt", [NI Reverse Amt] },
                { "AI Amount", [AI Amount], "AI Reverse Amt", [AI Reverse Amt] }
            }
        ), type table
    )
in
    #"Added Custom"