Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Having Trouble Creating New Calculated Column

  Hi Folks,   Can someone have a look at the ERD above and advise. I am sure it is only something small.   We are trying to create a new Calculated Column that multiplies Product_Vendors[M...
amitchandak's avatar
amitchandak
Super User
6 years ago

Try like

sumx(summarize(Product,product[product_id],"_1",sum(Customer_Order_Details[QuantityOrdered] ),"_2",max(Product_Vendors[Margin])),[_1]*[_2])

OR

sumx(summarize(Product,product[product_id],"_1",sum(Customer_Order_Details[QuantityOrdered] ),"_2",sum(Product_Vendors[Margin])),[_1]*[_2])