topic Re: Create a table that increase 1 hour since a date until today () in DAX Commands and Tips

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

luisecp — Sat, 13 Nov 2021 03:33:31 GMT

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

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

VahidDM — Sun, 14 Nov 2021 23:10:02 GMT

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/

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

Anonymous — Tue, 16 Nov 2021 02:14:45 GMT

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.