Forum Discussion
Solved
Count rows filtered by duration
it seems straightforward but I am at a loss. I have a data set that that i have been able to create a column for duration in hours minutes and seconds 12:12:12 now I need to count the rows o...
pgiorgi1 , Create a new column like
Bucket =
var _sec = hours([Time])*3600 +Minute([Time])*60 + Second([Time])
return
Switch(True(),
_sec <30 , " 0- 30 Sec",
_sec <60 , " 30- 59 Sec",
_sec<300, "<5 Mins" ,
_sec<600, "<10 Mins" ,
"More than 10 Mins"
)
Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56
FreemanZ
Super User
Super Userwhat does 0 or 1 mean for Duration?