Sum rows in power query

[NikD]

Hi guys, 

i have a table and need to summ the Amounts based on 2 columns : issue date and customer name , so same customer on the same day would be shown as 1 row with amount summarised.  I assume power query will do, but how? 

IssueDate                        CustomerName                                        Sum

03/10/2022	UMBRELLA LOUNGE BAR	88.69
03/10/2022	UMBRELLA LOUNGE BAR	90
04/10/2022	FINE GOURMET DELI	110.4
04/10/2022	LIMOR'S RESTAURANT	279.39
04/10/2022	KAZACHOK	384.92
04/10/2022	KAZACHOK	76.38

03/10/2022	UMBRELLA LOUNGE BAR	178.69
04/10/2022	FINE GOURMET DELI	110.4
04/10/2022	LIMOR'S RESTAURANT	279.39
04/10/2022	KAZACHOK	461.30

thanks,

NIK

[AntrikshSharma · Accepted solution]

@NikD Paste this in Advanced Editor in Power Query.

let
    Source = Table.FromRows (
        Json.Document (
            Binary.Decompress (
                Binary.FromText (
                    "xZA5CsMwEEWvIlQbebSgpZQTxRHWArLV2PExcv8IUiRgCO7SDf+/X7zZNgy8p9AzYAx3uMahuBAsCrmm0aHBlpZqTaTBe3cKNvAmxRd588mhMdcS3YKuLviWUQpEHNHgYy6PJwBTMypuXmwtNi2tYcoQbo6Lya72cs9TO7kWxLCfiJKE67MuVH3M/+EjJCW8/XN/AQ==",
                    BinaryEncoding.Base64
                ),
                Compression.Deflate
            )
        ),
        let
            _t = ( ( type nullable text ) meta [ Serialized.Text = true ] )
        in
            type table [ IssueDate = _t, CustomerName = _t, Sum = _t ]
    ),
    ChangedType = 
        Table.TransformColumnTypes (
            Source,
            { { "IssueDate", type date }, { "CustomerName", type text }, { "Sum", type number } }
        ),
    GroupedRows =
        Table.Group (
            ChangedType,
            { "IssueDate", "CustomerName" },
            { { "Sum", each List.Sum ( [Sum] ), type nullable number } }
        )
in
    GroupedRows

[wdx223_Daniel]

NewStep=Table.Group(PreviousStepName,{"IssueDate","CustomerName"},{"Sum",each List.Sum([Sum])})