topic Re: Minutes to Hours to Days Calculator in DAX Commands and Tips

Minutes to Hours to Days Calculator

LFrench — Wed, 19 Mar 2025 17:05:10 GMT

Greetings,

I am doing some work on a previously built PowerBI Dashboard, and have the following cacluated field, but it doesn't seem to be working correctly. It works great for anything that is greater than 60 minutes, but anything less than 60 minutes comes up as (BLANK). I'm guessing it's just a little issue, but I can't seem to figure out what's missing.

Minimum Time for Completion = IF(SUM('Course Information'[MIN])/60>=1&&SUM('Course Information'[MIN])/1440<1,ROUND(SUM('Course Information'[MIN])/60,2)&" Hours",

IF(SUM('Course Information'[MIN])/1440>=1,ROUND(SUM('Course Information'[MIN])/1440,2)&" Day"))

Thanks for any help you can provide!

Re: Minutes to Hours to Days Calculator

Deku — Wed, 19 Mar 2025 18:26:08 GMT

Var mins = SUM('Course Information'[MIN])

Return

Switch(

True,

Mins < 60, mins & " minutes",

Mins < 1440, round(divide(mins, 60),2) & " hours",

Mins >= 1440, round(divide(mins, 1440),2), & " days"

)

Re: Minutes to Hours to Days Calculator

LFrench — Sat, 22 Mar 2025 14:42:16 GMT

I attempted this, but got the following error:

Re: Minutes to Hours to Days Calculator

Deku — Sat, 22 Mar 2025 14:50:21 GMT

Need to add this at the start to name the measure

Minimum Time for Completion =

Re: Minutes to Hours to Days Calculator

AnkitKukreja — Mon, 24 Mar 2025 07:48:49 GMT

Hi! LFrench

Try this, also attaching the pbix.

MinimumTimeForCompletion =

VAR TotalMinutes = SUM('Time'[Mins])

VAR TotalHours = INT(TotalMinutes / 60)

VAR RemainingMinutes = MOD(TotalMinutes, 60)

VAR TotalDays = INT(TotalMinutes / 1440)

VAR RemainingHours = INT(MOD(TotalMinutes, 1440) / 60)

VAR RemainingDayMinutes = MOD(TotalMinutes, 60)

RETURN

IF(

TotalMinutes >= 1440,

TotalDays & " Day" & IF(TotalDays > 1, "s ", " ") & RemainingHours & " Hour" & IF(RemainingHours > 1, "s ", " ") & RemainingDayMinutes & " Minute" & IF(RemainingDayMinutes > 1, "s", ""),

IF(

TotalMinutes >= 60,

TotalHours & " Hour" & IF(TotalHours > 1, "s ", " ") & RemainingMinutes & " Minute" & IF(RemainingMinutes > 1, "s", ""),

TotalMinutes & " Minute" & IF(TotalMinutes > 1, "s", "")

)

Sample solution -