Forum Discussion

pierre's avatar
pierre
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Create a new table in power BI with SUMMARIZE function

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's avatar
    Sean
    10 years ago

    pierre You need to give a name to the New Sum Column :smileyhappy:

     

    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] )
)

     

2 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    pierre You need to give a name to the New Sum Column :smileyhappy:

     

    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] )
)