cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MashaIvleva Frequent Visitor
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
Community Support Team
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.

    1.png

   
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
Community Support Team
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.

    1.png

   
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.
Highlighted
Community Support Team
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.