cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Calendar with time intervals

Dear users,

I am currently looking into an easy function to make a calendar of say 10 years, but with 15min intervals.

Preferably to look like:

01-01-2010 00:00

01-01-2010 00:15

etc

Ideas?

Many thanks beforehand!

1 ACCEPTED SOLUTION
Community Support

Hi @Anonymous,

Based on my test, we can take the following steps to meet your requirement.

• Enter a time table from 00:00 – 23:45 named Time.
• Use the formula below to create a calculate table.
```DateTime =
CROSSJOIN (
CALENDAR ( DATE ( 2000, 1, 1 ), DATE ( 2010, 12, 31 ) ),
'time'
),
"DateTime", [Date] + [Time]
)```
• Then we can get a column that we need.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/zle0j2a9mi4l7vc/Calendar%20with%20time%20intervals.pbix?dl=0

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
2 REPLIES 2
Community Support

Hi @Anonymous,

Based on my test, we can take the following steps to meet your requirement.

• Enter a time table from 00:00 – 23:45 named Time.
• Use the formula below to create a calculate table.
```DateTime =
CROSSJOIN (
CALENDAR ( DATE ( 2000, 1, 1 ), DATE ( 2010, 12, 31 ) ),
'time'
),
"DateTime", [Date] + [Time]
)```
• Then we can get a column that we need.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/zle0j2a9mi4l7vc/Calendar%20with%20time%20intervals.pbix?dl=0

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Community Support

Hi @Anonymous,

Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.