Forum Discussion
Hourly Table using DAX
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.
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.
4 Replies
Have you considered using GENERATESERIES(0,23) ?
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?
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.
Thanks lbendlin . I made a use of power query as you mentioned about cardinality.
