Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi There,
I need to calculate the total sum of the hours worked by the hourly cost of each employee that are in two different tables
| EMPLOYER | |
| COD_Emp | Cost- Hour |
| 001 | $ 15.000 |
| 002 | $ 23.000 |
| 003 | $ 4.000 |
| 004 | $ 6.500 |
| 005 | $ 25.000 |
| 006 | $ 12.000 |
| 007 | $ 15.000 |
| 008 | $ 19.000 |
| RECORD | ||
| COD_Emp | Hour | Date |
| 008 | 2,5 | 1/01/2020 |
| 001 | 1 | 1/01/2020 |
| 007 | 3 | 1/01/2020 |
| 001 | 9 | 2/01/2020 |
| 003 | 4 | 2/01/2020 |
| 005 | 3 | 2/01/2020 |
| 008 | 2 | 2/01/2020 |
| 005 | 2 | 2/01/2020 |
| 002 | 3 | 1/01/2020 |
| 003 | 2 | 2/01/2020 |
| 007 | 6 | 1/01/2020 |
| 008 | 7 | 3/01/2020 |
| 001 | 3 | 3/01/2020 |
| TOTAL | |
| Jan | ? |
| Feb | ? |
| Mar | ? |
Please, your help. thanks
This looks similar to this recent post:
https://community.powerbi.com/t5/Desktop/Measure-with-row-level-calculations/m-p/1677916
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 10 | |
| 10 | |
| 8 |