Forum Discussion

sam_nik12345's avatar
sam_nik12345
Icon for Helper II rankHelper II
4 years ago
Solved

create new column multiplying values from other table

How can a create a new column by multiplying values from other column. My tables look like below. How do I get reqd column? Kindly help.     month value qty reqd jan 2 1 value * qty ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    sam_nik12345 ,

     

    new column

     

    reqd = [value] *[Qty]

    reqd = sumx(Table,[value] *[Qty])

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

 

reqd CC =
'Table'[value] * 'Table'[qty]