Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@TapZxK 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)
@TapZxK 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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |