Forum Discussion

mikesdunbar's avatar
mikesdunbar
Helper I
3 years ago
Solved

Weekly 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   ...
Need Help
  • Uspace87's avatar
    Uspace87
    3 years ago

    Try with this measure:

     

    Amt billed = Sumx(NATURALINNERJOIN(Table1,Table2), 'Billing Rate'[Billing Rate (USD)]*'Hours Worked'[Hours worked])

     

     

Uspace87's avatar
Uspace87
Resolver III
3 years ago

Try with this measure:

 

Amt billed = Sumx(NATURALINNERJOIN(Table1,Table2), 'Billing Rate'[Billing Rate (USD)]*'Hours Worked'[Hours worked])

 

 

mikesdunbar's avatar
mikesdunbar
Helper I
3 years ago

That did it, thank you!