Power Query: A new column with a sum amount from another column which contains [List]

[Anonymous]

Heya ladies and gentlemen,

I have a dataset and in this dataset there's one column, which contains a List. I can expand this list to new rows, but this creates also duplicate rows, which I do not want. However, I'd like to know the total sum of this List and sum it to a new column so that there's no duplicate rows.

I think you should use some kind of List.Sum or similar function to do this, but I cannot get it to work. Any ideas fellas? 

Thanks.

[v-piga-msft]

Hi @attehaa,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask and describe your scenario in more details.

In addition, you could have a reference of this similar threads,

http://community.powerbi.com/t5/Desktop/Expand-colum-with-lists/m-p/53290

https://community.powerbi.com/t5/Desktop/row-duplication-when-expanding-a-table-column/m-p/85846

Best  Regards,

Cherry

[jthomson · Accepted solution]

Could you not try to expand the lists, and then use the grouping function, summing on this column?