In Power Query, there is an easy way to use Duration and get the number of days, hours, minutes and seconds from it. However, sometimes you need this calculation to be dynamic as a measure in DAX. I had that requirement too. And I wrote a simple DAX calculation which will give you the result. If you like to know more about Power BI, read Power BI book from Rookie to Rock Star.

You have the duration in Minutes and want to calculate Hours/Minutes

If you have the duration in Minutes and want to calculate it in hours and minutes. this is a DAX measure that can help with that.

*Note: The [Duration in Minutes] part of the expression below should be replaced with the value/field/measure you have the minutes coming from it.

Read More

Share This