Remove Duplicate from Aggregated Column

Hi -

You can use "Group By" in the "Transform" tab of Power Query. Use the advanced option and group by each row in order. Then when the grouping is done you can delete the column that holds the summary.

Here is an example you can cut-and-paste into the Advanced Editor and walk through to see what it does:

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQ30zcyMDJS0lEyAWIQHZJRWlScklgJZBoCsZ8ziGFkYKpnbq4Uq0O6llgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ShipDate = _t, Weekday = _t, WeekNumber = _t, DayOfWeek = _t, Quarter = _t, Lane = _t, AggregatedCubes = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"ShipDate", type date}, {"Weekday", Int64.Type}, {"WeekNumber", Int64.Type}, {"DayOfWeek", type text}, {"Quarter", Int64.Type}, {"Lane", type text}, {"AggregatedCubes", type number}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"ShipDate", "Weekday", "WeekNumber", "DayOfWeek", "Quarter", "Lane", "AggregatedCubes"}, {{"Count", each _, type table [ShipDate=nullable date, Weekday=nullable number, WeekNumber=nullable number, DayOfWeek=nullable text, Quarter=nullable number, Lane=nullable text, AggregatedCubes=nullable number]}}),
#"Removed Columns" = Table.RemoveColumns(#"Grouped Rows",{"Count"})
in
#"Removed Columns"

Hope this helps!

Peter