Forum Discussion
Solved
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 re...
Scratch that, I've fiddled with Advanced Query and got it work. Thank you for your swift eligant solution.
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.