Create a table that increase 1 hour since a date until today ()

[luisecp]

I want to create a table that increase 1 hours since one date "01/01/2021" until now

Datetime

01/01/2021 00:00:00

01/01/2021 01:00:00

01/01/2021 02:00:00

01/01/2021 03:00:00

01/01/2021 04:00:00

.

.

.

TODAY

Regards

Luis

[v-xiaoyan-msft]

Hi @luisecp ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM · Accepted solution]

Hi @luisecp 

Try this code to create a new table:

Table = 
GENERATESERIES ( DATE ( 2021, 01, 01 ), NOW (), TIME ( 01, 00, 00 ) )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/