Forum Discussion

gbarredap's avatar
gbarredap
Regular Visitor
9 years ago
Solved

Multiply columns

I need to multiply 2 different columns; hours and rate per hour. The issue here is that I have different rates for different ranks and each project is the sum of the multiplication of hours at differ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi gbarredap,

     

    If I understand you correctly, there is a relationship between ARMS and PL, to calculate multiplication then add total, you can create a measure in PL table like below:

     

    Measure 2 = SUMX('PL',PL[Person Billing Rate]*RELATED(ARMS[total]))

     

     

    If the above measure doesn't work, please share some sample data and expected results for our analysis.

     

    Best Regards,

    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi gbarredap,

 

If I understand you correctly, there is a relationship between ARMS and PL, to calculate multiplication then add total, you can create a measure in PL table like below:

 

Measure 2 = SUMX('PL',PL[Person Billing Rate]*RELATED(ARMS[total]))

 

 

If the above measure doesn't work, please share some sample data and expected results for our analysis.

 

Best Regards,

Qiuyun Yu