Hourly Table using DAX

[amit_maniyar]

Hi All, 

here is the scenario; I want to create an hourly table using generateseries function as shown in the picture.
I am not sure if I am making any mistake. but ,I am supposed to see the hourly series here which should not have hour portion "59:59". 

I have attached 2 images here one of them shows as "mm/dd/yyy 00:00:00" sorted ascending and another one shows  "mm/dd/yyy 59:59:59" - which I would not want & dont know how it is giving me values like this!!

I liked using dax instead of power query because I find DAX simpler.

I tried to read relative posts, but could not find the exact one. 

any help would be appreciated.   

[amit_maniyar]

Thanks @lbendlin . I made a use of power query as you mentioned about cardinality.

[amit_maniyar]

Generateseries(0,23) won't give me date right ? I want date and time (hourly breakdown) as well.

 Do you know any workaround to this?

[lbendlin · Accepted solution]

Think of the cardinality. A hourly table has 24 entries. A minute table has 1440 rows. A time table has 86400 rows.  This will quickly become unmanageable.

[lbendlin]

Have you considered using GENERATESERIES(0,23)  ?