Multiplying Row Values

[Anonymous]

I have a table with a list of items column and a multiplier value (1.XX) column. Some of the items appear more than once, and I want to create a new table with the item listed once and the product of the multiplier values to get the total multiplier for each item.

I know this is a newb question, but I'm unsure how to do. Thanks.

[v-jingzhang · Accepted solution]

Hi @Anonymous 

If you want something like PRODUCT funtion in Excel, there is also PRODUCT and PRODUCTX function in DAX. In this case, you can use below DAX code to create a new table. 

New Table = SUMMARIZE('YourTable','YourTable'[Item],"Total multiplier",PRODUCT('YourTable'[Multiplier]))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[sm_talha]

Can you provide a small sample of your data?