cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper II

Calculate Time Data into Hours & Minutes using SUM

I am trying to show SUM of total hours for each activity

Hours & Minutes column can't be set as TIME so unsure how to show visual with aggregate SUM

TimeHours & MinutesMinutesMinjutes as ValuesTime Spent

 0:05:32 00:05 05 5 Over 40 1:00:18 01:00 60 60 Over 40 0:25:42 00:25 25 61 Over 40 1:00:12 01:00 60 62 Over 40 0:51:05 00:51 51 63 Over 40 0:22:50 00:22 22 64 Over 40

I can make it work using Minutes column but I want to see visual in Hours & Minutes

2 ACCEPTED SOLUTIONS
Super User

Yes.  Multiply the duration by 24, that will give you the hours with fractions.

Super User

Depends on how you get the original duration. Remember that you cannot create columns from measures.

7 REPLIES 7
Solution Sage

Please see this article for how to handle durations. It shows how to keep them stored as decimals (for aggregations, visuals, etc.) but display as you want with FORMAT as needed (e.g., in a tooltip).

Calculate and Format Durations in DAX – Hoosier BI

Pat

Microsoft Employee
Super User
``but I want to see visual in Hours & Minutes``

How would that scale look like?  Hours and fractions, or hours and quarters?  You won't be able to show a mixed scale on the Y axis of a Column chart.

Helper II

Would it be possible to show as decimals? Eg: 6 and a half hours is 6.5

Super User

Yes.  Multiply the duration by 24, that will give you the hours with fractions.

Helper II

@lbendlin Thanks - I feel I am close but not quite.

Do I do this by adding a new column with 24 then create a Measure to multiply by Duration by the New Column?

Super User

Depends on how you get the original duration. Remember that you cannot create columns from measures.

Helper II

Thanks @lbendlin this worked 🙂

Announcements

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors