Forum Discussion

gbarredap's avatar
gbarredap
Regular Visitor
10 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
    10 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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi gbarredap

 

Could please share your data model and the expected output to find a solution.

 

Cheers

 

CheenuSing