Forum Discussion
Solved
Dax help
Hello, I have a column called CheckIn Time. Data type: Text , Format: Text, Data category: Uncategorized. I want to create a new column called Period of the day. Same like the one in the pi...
Samiks95 , Create a new column
=
var _time = timevalue([Checkin time])
return
Switch( True() ,
_time < time(7,0,0) , "Early Morning",
_time < time(7,0,0) , "Last Morning",
// add other
"Late Night")
Change as per need
amitchandak
Super User
Super UserSamiks95 , Create a new column
=
var _time = timevalue([Checkin time])
return
Switch( True() ,
_time < time(7,0,0) , "Early Morning",
_time < time(7,0,0) , "Last Morning",
// add other
"Late Night")
Change as per need