Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Average hourly Income. Help with formula please

Hi All, 

 

Here I am again with another question for my Power BI Report.

 

What I'm looking to find out is the hourly Income for projects. the logic should be like so. 

 

For Project Sparrow Total Billed in September is 100,000 Euro and total reported hours for Sparrow in September are 1200 Hours.

For Project Legacy Total Billed in September is 16,000 Euro and total reported hours for Legacy in September are 360 hours.

 

Sparrow Total Billed / Total Hours = 83.3 Euro hourly rate.

Legacy Total Billed / Total Hours = 44.4 Euro hourly rate.

Overall Total Billed / Overall total Hours = 74.3 euro hourly rate.

 

I have the following tables:

 

Resource Hours (Data)

Project Billings (Data)

connected to

Project_Lookup (Lookup Table)

Calendar (Lookup Table)

 

Thank you for your help. 

 

BR,

Kris

 

 

Need Help
  • JirkaZ's avatar
    JirkaZ
    6 years ago

    Anonymous This should be a simple measure like:

    CALCULATE(DIVIDE(SUM(money), SUM(hours), 0)
    The rest should be evaluated within a context (table visual with project rows and this measure added)

1 Reply

  • JirkaZ's avatar
    JirkaZ
    Solution Specialist
    6 years ago

    Anonymous This should be a simple measure like:

    CALCULATE(DIVIDE(SUM(money), SUM(hours), 0)
    The rest should be evaluated within a context (table visual with project rows and this measure added)