Create a new table in power BI with SUMMARIZE function

[pierre]

Hello,

I try to create a new table  from another to sum a column group by item number and year.

Here is my formula :

NewTable = SUMMARIZE(LOG_DELIV_NOTE;'LOG_DELIV_NOTE[SHIPPED_ORDER_YEAR];LOG_DELIV_NOTE[ITEM_NUMBER];sum(LOG_DELIV_NOTE[M_DELIVERED_QTY])

and here is the error :

The following syntax error occurred during parsing: Invalid token, Line 1, Offset 26, 'LOG_DELIV_NOTE[SHIPPED_ORDER_YEAR];LOG_DELIV_NOTE[ITEM_NUMBER];sum(LOG_DELIV_NOTE[M_DELIVERED_QTY])
).

Do you know what it means and how to resolve it?

Regard

Pierre

[Sean · Accepted solution]

@pierre You need to give a name to the New Sum Column 

NewTable =
SUMMARIZE (
    LOG_DELIV_NOTE;
    LOG_DELIV_NOTE[SHIPPED_ORDER_YEAR];
    LOG_DELIV_NOTE[ITEM_NUMBER];
    "New Sum Column"; SUM ( LOG_DELIV_NOTE[M_DELIVERED_QTY] )
)

[pierre]

Thanks a lot Sean : it works!