Summarizing rows in Query Editor

[bchager6]

Hi everyone...

I want to summarize the Capex numbers in the below table, by Project ID, so I can then delete the "Month" column and then have only 1 row per Project ID. Does anyone know if this is possible in Query Editor? If so, what are the steps?

Thanks in advance to anyone who can assist.

[v-xuding-msft]

Hi @bchager6 ,

@Greg_Deckler  is right. You could try “Group By”. Please take a look at the blog to have a try.

Grouping rows with Power BI / Power Query 

[Greg_Deckler · Accepted solution]

@bchager6 You can use the Group By operation in Power Query Editor.

In DAX it is SUMMARIZE and GROUPBY