Calendar with time intervals

[Anonymous]

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!

[v-frfei-msft · Accepted solution]

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

[v-frfei-msft]

Hi @Anonymous,

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

Regards,
Frank