How to create a aggregated table with additional criteria?

[Kathir]

   

How to create an aggregated table below based on the table on top? Time is ascending for the top table. Thanks 

[Anonymous · Accepted solution]

Hi @Kathir,

You can use the summarize function to create a new calculated table to aggregate specific field values based on category fields:

Summaried =
SUMMARIZE (
    Table1,
    Table1[ID],
    Table1[Day],
    Table1[Venue],
    Table1[Zone],
    "Duration(sec)", SUM ( Table1[Duration(sec)] )
)

Regards,

Xiaoxin Sheng

[Kathir]

if you have noticed, refering to the top table, as long as the venue is same row 3 and row 4 (records which are adjacent), i have added 56 + 152 , the result table below shows 208

[lukiz84]

ah, now i see.

Do it in PowerQuery, like this: Grouping or Summarizing Rows in Power Query - BI Gorilla

[lukiz84]

can you be a little more specific?