Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 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

Need Help
Tips and Tricks

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Super User
    7 years ago

    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