Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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)
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!