Forum Discussion
Time Table
Hi, I am looking for a DAX function to create a time table from 00:00 to 23:59 in minutes steps. Has anyone a solution? Edit: Is there a visual that allows a selection between two values? So ...
OwenAuger
Super User
Super UserAnonymous
As far as creating such a table with DAX, you can use code like this:
Time =
SELECTCOLUMNS (
GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 59, 0 ), TIME ( 0, 1, 0 ) ),
"Time", [Value]
)
As far as a slicer that will allow you to select a time range and display time values formatted correctly, I'm afraid I can't find any existing built-in or custom visual that will do the job.
Perhaps someone else knows, or it could be a custom visual idea for someone?
Regards,
Owen