Forum Discussion
Help with modeling - duplicate values
Folks, need a help. I receive from a system the following table: Engagement ID Valeu USD Status 12345 100 Active 12345 200 Active 12345 -400 Active 12345 600 Active 12345...
You can use group by in the edit queries, then advance and add multiple column(Screenshot below)
I believe this can be achieved using Group By on power query.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQyNjFV0lEyNDAAko7JJZllqUqxOggJI1wSuia4ZMyIMysWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Engagement ID" = _t, #"Valeu USD" = _t, Status = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Engagement ID", Int64.Type}, {"Valeu USD", Int64.Type}, {"Status", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Engagement ID", "Status"}, {{"Value USD", each List.Sum([Valeu USD]), type number}})
in
#"Grouped Rows"