I have a measure which is a sum of all time calls per user. But If the that sum is more than 24 hours I have a problem with its displaying. I created a long code for solving that.
Code: Select all
Time Calls = Var allTime = Sum('Persons'[Call Time])
Var prefix = IF(DAY(allTime) > 30 || YEAR(allTime) = 1900; FORMAT(DAY(allTime + 2); "DD") & "d "); "")
RETURN IF(ISBLANK(allTime); BLANK(); prefix & FORMAT(allTime; "HH:mm:ss"))
But is there a way without such coding?