I have a Calculated time Difference Between Dates result are accurate when i see data datewise but in Subtotal Area i Want Sum.
How i can do this in Excel Power Pivot Data Model.
Measure
Time Spend in Hrs = DATEDIFF(MIN(B2B[Check In]),MAX(B2B[Check Out]),MINUTE)/60
result
Result i need Like this.
Helpful resources
Fabric Monthly Update - April 2026
Check out the April 2026 Fabric update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
