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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I need to substract hours from Reg hours column in Power BI. How can I achieve the Final hours calculation in power BI
| Employee | Leave Type | Trans hrs | Regular Hrs |
| ABC | SIck Leave | 8 | 40 |
| ABC | Annual Leave | 6 | 40 |
| ABC | DH Leave | 4 | 40 |
| XYZ | SIck Leave | 12 | 40 |
| XYZ | Annual Leave | 10 | 40 |
| XYZ | DH Leave | 8 | 40 |
Report requiremnt as below. I am able to get the below report in matrix by placing Leave type in column section of Matrix view. But unable to do substract RH-total hrs.
| Employee | Reg Hrs | SL | AL | DH | Total | Final Hrs |
| ABC | 40 | 8 | 6 | 4 | 18 | 40-18 |
| XYZ | 40 | 12 | 10 | 8 | 30 | 40-30 |
If these are columns you can use SUM Function Hrs = Sum('Table'[Hrs]) - Sum('Table'[Total Hrs])
You need to create a measure
Hrs = [Hrs] - [Total Hrs]
How do you pickup total hours, it will be generated dynamically. There is no column to hold total
Check out the November 2025 Power BI 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!
| User | Count |
|---|---|
| 99 | |
| 76 | |
| 56 | |
| 51 | |
| 46 |