Forum Discussion
Solved
How do I create a Time table using DAX?
I am working with tables that has time in 00:00:00 format. I'd like to create a Time table in this same format and use this to create a relationship with all of the other tables. I'd like it to go up...
GENERATESERIES( TIME(0,0,0), TIME(23,59,59), TIME(0, 0, 1) )but is it a good idea with 86,400 rows in the table?
GENERATESERIES(
TIME(0,0,0), TIME(23,59,59), TIME(0, 0, 1) )but is it a good idea with 86,400 rows in the table?