Forum Discussion
Solved
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...
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.
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.