Forum Discussion
Problems witha time format measure
Good afternoon to all, Maybe somene could help me out with this problem I am finding. I created a measure to show time as such 1:02:00 using this DAX Hours = FORMAT(time(0,sum('Descarga...
hi, Borjaveiga
replace your sum with min like below
just adjust table name
Measure =
FORMAT(TIME(0,min('Table'[registered_time_mins]),0),"HH:MM:SS")
Thanks for your quick answer, although that does not solve my problem, since that is a fact table and I need to sum all the minutes registred, its a fact table and I have several rows by Employee ID
hi, Borjaveiga
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).