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_DEL...
  • 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] )
)

     

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

 

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

Thanks a lot Sean : it works!