Time Table

[Anonymous]

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 I am able to choose "every value between 13:13 and 14:15". A Slicer only does it of the day level...

Best regards

Timo

[OwenAuger]

@Anonymous 

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