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?

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Helper II rankHelper II
    9 years ago

    Thanks Phil_Seamark ,

    Actually I am also Confused that it will work or not ? i mean it will give right Answer or not?

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      It should work and should be easy enough to test on some cut down tables.  

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

    Thanks Phil_Seamark , Yes Now its giving right Calculations.