Forum Discussion

JC-80's avatar
JC-80
New Member
10 years ago
Solved

Multiply Columns within different Tables - Not giving correct output...

Hi,    I am hoping someone can assist.    I have 2 tables of data Table A has all the data contained within it and Table B has unique fields - the relationship is Many to One.   Table A has Col...
Need Help
  • JC-80's avatar
    JC-80
    10 years ago

    In this example I managed to fix the issue. 

     

    I completed a merge on the 2 tables with the relevant data. This created a column that contained all of the columns from 'Table 2', so I picked 'Hourly Rates'. I then created a calculated column multiplying the 'Hours' column by the 'Hourly Rates' column, this gave me the desired outcome. 

     

    Thanks for everyones suggestions and help. :smileywink:

     

     

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi JC-80,

Could you please post the sample data of your two tables and post the expected result here?  Regrading to the above table, you can simply create a measure to summarize the cost by using the formula: Measure = SUMX(Table1,Table1[Hours]*Table1[Hours Rate]).




Thanks,
Lydia Zhang

JC-80's avatar
JC-80
New Member
10 years ago

In this example I managed to fix the issue. 

 

I completed a merge on the 2 tables with the relevant data. This created a column that contained all of the columns from 'Table 2', so I picked 'Hourly Rates'. I then created a calculated column multiplying the 'Hours' column by the 'Hourly Rates' column, this gave me the desired outcome. 

 

Thanks for everyones suggestions and help. :smileywink: