Forum Discussion

rakeshsaini's avatar
rakeshsaini
Icon for Helper II rankHelper 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

rakeshsaini's avatar
rakeshsaini
Icon for Helper II rankHelper II
9 years ago

I used this Formula for Now !!!

 

Measure--

 

result=SUMX(TABLE1,Related(TABLE2[PoundsPerCoil]) * TABLE1[Total Potential Coils Involved])

 

 

is it correct?

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
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