Help with hours and minutes

[Anonymous]

Hi all, first post here, and new to using power bi. I have a bit of an issue with time time duration, I have two fields StartTime and End time, I can calculate the duration of these two fields in the query, but what I'm struggling to do is, 1. Out put the duration in hours and minutes (I've managed to do this in DAX). 2. Use this output as a sum in the value field of the pivot table, I can't convert it from count. Any help would be appreciated.

[dedelman_clng]

Hi @Anonymous  - 

It would be helpful if you provided a sample of your data and whatever calculations you've done up until this point. See this post How-to-Get-Your-Question-Answered-Quickly (also pinned to the top of the forum) on the things you can do to help us help you.

That being said, you may want to try and write an aggregation and formatting measure for the value you want to put in a matrix, rather than relying on the functions accessible through dropdowns when you drag a column into a visual.

So instead of VALUES saying "Sum of Table[TimeDiff]", you write a measure that does the summing and formatting, then put that in the visual.

Again, if that doesn't make sense, please provide sample data and what you've attempted so far.

Hope this helps

David