Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!