Hi @AlfredvdM ,
yes, my bad.
Please try this solution:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dZA9TwMxDIb/S+arG9v58oqYKjbYqhtO6CQqJCrdCX5/46TQXEknO4mf19FzPBrc454skRkMkmWX6/PpZ17W+Su3zE6AMXc+CTMkbQNRYkAy4/CP51xf3z/OlXbkKr2LvknrcPr8Mk3L2uYPhrwwWNFLl2IA6sJx++k8SmU07w3oKZTV1j6g9fkwre2ODHrbJilGW0zuTJHIFcV6TA/AdK+4/uwGyi/IG9Cp26flPH+qmBQtJCoUe3Dqj2LusowOqvVt+T7plEgAX0nyEJuwDoh/chjzUHG5w8gQXZPVAe0NvKooCyOIb8LG8QI=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, Number = _t, Description = _t, #"Opening Balance" = _t, Transaction = _t, #"Closing Balance" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Number", Int64.Type}, {"Description", type text}, {"Opening Balance", type number}, {"Transaction", type number}, {"Closing Balance", type number}}),
#"Grouped Rows" = Table.Group(
#"Changed Type",
{"Date"},
{
{"OpeningPerDate", each Table.Buffer(Table.Sort(_, {"Number", Order.Ascending})){0}[Opening Balance]},
{"ClosingPerDate", each Table.Buffer(Table.Sort(_, {"Number", Order.Descending})){0}[Closing Balance]},
{
"Partition",
each _,
type table [
Date = nullable date,
Number = nullable number,
Description = nullable text,
#" Opening Balance" = nullable number,
Transaction = nullable number,
Closing Balance = nullable number
]
}
}
),
#"Expanded Partition" = Table.ExpandTableColumn(
#"Grouped Rows",
"Partition",
{"Opening Balance", "Transaction", "Closing Balance"},
{"Opening Balance", "Transaction", "Closing Balance"}
)
in
#"Expanded Partition"
