Forum Discussion

danialsj's avatar
danialsj
Frequent Visitor
6 years ago
Solved

Power Query - Filtering rows and adding a column for subtotals based on two columns

Data: Each 'Code' has multiple 'Amount' in a month. E.g. 1001 has two entries of 10 and 20 on 31st January.   Code Date Amount 1001 31/1/19 10 1001 31/1/19 20 1001 28/2/19 15 ...
Need Help
  • az38's avatar
    az38
    6 years ago

    hi danialsj 

    that's pretty much easy

    right click on the Code field. then "Group by" then Advanced then Add grouping and Sum of Amount as new column. like this

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    LinkedIn

     

az38's avatar
az38
Community Champion
6 years ago

hi danialsj 

that's pretty much easy

right click on the Code field. then "Group by" then Advanced then Add grouping and Sum of Amount as new column. like this

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn