New table for other table

[AmandaF]

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)

[sendilc]

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