Forum Discussion
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!
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
2 Replies
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
Hi Anonymous,
Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.
Regards,
Frank