Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiplying Row Values

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...
Need Help
Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    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's avatar
sm_talha
Icon for Resolver II rankResolver II
5 years ago

Can you provide a small sample of your data?