Minutes to Hours to Days Calculator

[LFrench]

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!

[AnkitKukreja · Accepted solution]

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 - 

[Deku]

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"

)

[LFrench]

I attempted this, but got the following error: 

[Deku]

Need to add this at the start to name the measure

Minimum Time for Completion =