Forum Discussion
Group interval 15 min by value
Hello dear community. I have a question about the intervals. I currently have an Interval column which I made like this: Time.from (Number.RoundDown (96 * Number.From (Time.From ([column1])) / 1) ...
Anonymous
This should do it:NewTarget = var getHour = HOUR(Interval2[Time 1]) var getMinute = MINUTE(Interval2[Time 1]) var IntervalToText = FORMAT(Interval2[Interval ],"h:mm") var checkInterval = if(getMinute>=45,getHour & ":45 - " & getHour & ":59",IntervalToText) return checkInterval
vojtechsima
Super User
Super UserAnonymous , I am glad to hear that, please, if you could mark my original reply as the solution, so this threat is closed. Thank you