Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

New table for other table

I Have a dataframe like this

 

I would like to create a new table transforming the months columns (April and may) in just one column like this. Because the sum of the payment column by column A must stay as it is in first dateframe, (If I create a sum metric, it returns  1299 for A30FF)

 

 

 

 

Need Help

1 Reply

  • sendilc's avatar
    sendilc
    Frequent Visitor
    3 years ago

    Hi, 

    Pls check the below solution.. 

     

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcjQ2cHNT0lEyNLK0BFKWBgZA0hjIjtUBShoaufkA+aYGYGEjUwQFljYxdXMHaQJrNYCyYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [OrderNo = _t, Payment = _t, April = _t, May = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Payment", Int64.Type}, {"April", Int64.Type}, {"May", Int64.Type}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"OrderNo", "Payment"}, "Month", "Value")
    in
    #"Unpivoted Columns"

     

    Regards