cancel
Showing results for
Search instead for
Did you mean:
Frequent Visitor

## 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

Accepted Solutions
Highlighted
Community Support Team

## Re: Calendar with time intervals

Hi @MashaIvleva,

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 =
ADDCOLUMNS (
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 other members find it more quickly.
2 REPLIES 2
Highlighted
Community Support Team

## Re: Calendar with time intervals

Hi @MashaIvleva,

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 =
ADDCOLUMNS (
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 other members find it more quickly.
Community Support Team

## Re: Calendar with time intervals

Hi @MashaIvleva,

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 other members find it more quickly.