Forum Discussion
Is there a Reverse Summarize or De-Summarize function!
I have a table which summarizes product price and frequency. I wish to perform a number of statistical functions on the table, such as average, standard deviation and wish to use some visuals that require the data in a single coloum de-summarised: - How do I best do this?
Current table:
Price, Frequency
12.99, 3
4.50, 1
8.95, 3
Desired column:
12.99
12.99
12.99
4.50
8.95
8.95
8.95
Scratch that, I've fiddled with Advanced Query and got it work. Thank you for your swift eligant solution.
3 Replies
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTSs7RU0lEyVorViVYy0TMFsg3BbAs9S1OIRCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Price = _t, Frequency = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Price", type number}, {"Frequency", Int64.Type}}), Repeated = Table.CombineColumns(#"Changed Type", {"Price", "Frequency"}, each List.Repeat({_{0}}, _{1}), "Price"), #"Expanded Price" = Table.ExpandListColumn(Repeated, "Price") in #"Expanded Price"Thank you, because my expertise in Advance Editor is limited. Can the answer be simplified and expressed as individual Power Query steps? or as a New Measure in PBI using AverageX perhaps?
Scratch that, I've fiddled with Advanced Query and got it work. Thank you for your swift eligant solution.
