Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

24 Hour Time Table for TODAY?

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?

 

2 REPLIES 2
Anonymous
Not applicable

Hi, something like this?

TimeTable =
GENERATESERIES (
TODAY() ,
TODAY() +1,
TIME ( 0, 1, 0 )
)
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.