Forum Discussion
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...
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
Hi gbarredap
Could please share your data model and the expected output to find a solution.
Cheers
CheenuSing