24 Hour Time Table for TODAY?

[Anonymous]

Hey folks - I'm looking to create a Time Dimension table so it's always set to today.

So for instance today I want to have 9/7/2021 12:00:00AM for the first row, then 9/7/2021 12:00:01 AM etc etc. Is there a calculated table code I can use to create this? Maybe even add in a column for hour buckets?

[Dom39999]

Hi, something like this?

TimeTable =

GENERATESERIES (

TODAY() ,

TODAY() +1,

TIME ( 0, 1, 0 )

)

[lbendlin]

1.  Create a calculated table

TodayCal = GENERATESERIES(0,86399)

2. Add two calculated columns

TS = TODAY()+divide(TodayCal[Value],86400)

Hr = hour(TodayCal[TS])

Of course you could do the same in Power Query too.