Forum Discussion

rakeshsaini's avatar
rakeshsaini
Helper II
9 years ago
Solved

Get the Multipication of two Column

Hi Team ,  I have a TABLE1 , TABLE1 have COLUMN A , COLUMN  B . And I also have Another Table TABLE2 , it have COLUMN C , COLUMN D. Column A have Realtionship with Column B (Many to one) .   I Wan...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

     

    How about this

     

    New Column = Table1[Total Potential Coils Involved] * RELATED('Table2'[PoundsPerCoil])

    And if you want to sum up that column create a measure over it 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi rakeshsaini,

    The syntax of your formula: result=SUMX(TABLE1,Related(TABLE2[PoundsPerCoil]) * TABLE1[Total Potential Coils Involved])  is right. While you should create a calculated column in Table1 based on my understanding.

     

    You can create a calculated column in Table1 using the formula.

    Related(TABLE2[PoundsPerCoil]) * TABLE1[Total Potential Coils Involved]


    What's your opinion?

    Best Regards,
    Aneglia

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

 

How about this

 

New Column = Table1[Total Potential Coils Involved] * RELATED('Table2'[PoundsPerCoil])

And if you want to sum up that column create a measure over it 

rakeshsaini's avatar
rakeshsaini
Helper II
9 years ago

Thanks Phil_Seamark , Yes Now its giving right Calculations.