Forum Discussion
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...
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