Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
littlepatos
Helper II
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

 

littlepatos_0-1675482730155.png

TimeHours & MinutesMinutesMinjutes as ValuesTime Spent

0:05:3200:05055Over 40
1:00:1801:006060Over 40
0:25:4200:252561Over 40
1:00:1201:006062Over 40
0:51:0500:515163Over 40
0:22:5000:222264Over 40

 

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

littlepatos_1-1675482818064.png

 

 

2 ACCEPTED SOLUTIONS

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

View solution in original post

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

View solution in original post

7 REPLIES 7
ppm1
Solution Sage
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
lbendlin
Super User
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.

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

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

@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? 

littlepatos_0-1675567190073.png

 

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

Thanks @lbendlin this worked 🙂

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.