Forum Discussion
mikesdunbar
Helper I
Helper IWeekly billing amounts
Hello, I'm trying to calculate the weekly billing amounts for individuals based on their job title. There are two spreadsheets that cover this. First spreadsheet Includes Job Code and Rate ...
Try with this measure:
Amt billed = Sumx(NATURALINNERJOIN(Table1,Table2), 'Billing Rate'[Billing Rate (USD)]*'Hours Worked'[Hours worked])
Uspace87
Resolver III
Resolver IIITry with this measure:
Amt billed = Sumx(NATURALINNERJOIN(Table1,Table2), 'Billing Rate'[Billing Rate (USD)]*'Hours Worked'[Hours worked])
mikesdunbarHelper I
Helper IThat did it, thank you!