Forum Discussion
Time/Duration Value Display
I am looking for a way to display total duration that is over 24 hours. Currently if the sum of two durations is 34:22 hours it will display as: 10:22 This must be because the Power BI...
I would try this, the format is text
Measure = VAR Hours = INT([Total Duration]*24) VAR Minutes = RIGHT(FORMAT([Total Duration],"hh:mm"),2) RETURN Hours & ":" & Minutes
try this
Measure = VAR Hours = INT([Total Duration]*24) VAR Minutes = RIGHT(FORMAT([Total Duration],"hh:mm"),2) VAR Separator = IF([Total Duration]=BLANK(),BLANK(),":") RETURN Hours & Separator & Minutes
Currently my formula is... Worked = SUMX(SUMMARIZE(VALUES(ReportA_PQ[Date]),[Date],"ABCD",[Logout]-[Login]-[Lunch]),[ABCD])
anyone have any ideas?