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 Want to Get the  Multipication of Values Of COLUMN B AND COLUMN D . How can i get it ?

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

12 Replies

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

    I am Thniking that , is it Possible to Create a Another Table With one Column , that Column Have Multipication Data of those Columns.

    • MarcelBeug's avatar
      MarcelBeug
      Icon for Community Champion rankCommunity Champion
      9 years ago

      Well, it's quite logical that column A has a relation with column B as they are in the same table: probably the value in column B belongs to the value in column A in the same row...

      But what would be the relationship between Table1 and Table2???

       

      Anyhow, as you can see in this video, I created some data in Excel with an additional column COL A to link Table 2 to Table 1 and used Power Query to load them in the datamodel, merge them together and multiply columns B and D.

       

      Similarly, you can merge 2 tables in the Query Editor of Power BI.

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

        Thanks MarcelBeug ,

        TABLE1 and TABLE2 has Many to one Realtionship .

        Yes I Expain this Problem.

        TABLE1 Data Columns , Plz see below

         

         

        and TBALE2 has below Columns

         

         

        -TBALE1 COLUMN "Part Number Size" has 'Many to one' Realtionship with TABLE2 COLUMN "ProductID" .

        Now , I Need to Calculate the Multipication of TABLE1 COLUMN 'Total Potential Coil ' with TABLE2 COLUMN 'Pound Per Coil' respectively .  it Means we will do Multipication Using Many to one Realtionship.!!!