Date table including Interval

[Jorgast]

Hello Power BI Friends,

I need to create a date / interval table dataset. Currently i am using the Generate / Calendar function so i can get a rolling years. but i am not sure how to get the interval data. My data tables come in as 30 minute intervals by date. How to do i create a table that has the Date + time

Interval TEST =

GENERATE ( CALENDAR( DATE( YEAR( TODAY() ) - 3, MONTH( TODAY() ), DAY( TODAY()) ), TODAY()),

Example:

Date	Interval	Date Interval
6/1/2019	12:00 AM	6/1/2019 0:00
6/1/2019	12:30 AM	6/1/2019 0:30
6/1/2019	1:00 AM	6/1/2019 1:00
6/1/2019	1:30 AM	6/1/2019 1:30
6/1/2019	2:00 AM	6/1/2019 2:00
6/1/2019	2:30 AM	6/1/2019 2:30
6/1/2019	3:00 AM	6/1/2019 3:00
6/1/2019	3:30 AM	6/1/2019 3:30
6/1/2019	4:00 AM	6/1/2019 4:00
6/1/2019	4:30 AM	6/1/2019 4:30
6/1/2019	5:00 AM	6/1/2019 5:00
6/1/2019	5:30 AM	6/1/2019 5:30
6/1/2019	6:00 AM	6/1/2019 6:00
6/1/2019	6:30 AM	6/1/2019 6:30
6/1/2019	7:00 AM	6/1/2019 7:00
6/1/2019	7:30 AM	6/1/2019 7:30
6/1/2019	8:00 AM	6/1/2019 8:00
6/1/2019	8:30 AM	6/1/2019 8:30
6/1/2019	9:00 AM	6/1/2019 9:00
6/1/2019	9:30 AM	6/1/2019 9:30
6/1/2019	10:00 AM	6/1/2019 10:00
6/1/2019	10:30 AM	6/1/2019 10:30
6/1/2019	11:00 AM	6/1/2019 11:00
6/1/2019	11:30 AM	6/1/2019 11:30
6/1/2019	12:00 PM	6/1/2019 12:00
6/1/2019	12:30 PM	6/1/2019 12:30
6/1/2019	1:00 PM	6/1/2019 13:00
6/1/2019	1:30 PM	6/1/2019 13:30
6/1/2019	2:00 PM	6/1/2019 14:00
6/1/2019	2:30 PM	6/1/2019 14:30
6/1/2019	3:00 PM	6/1/2019 15:00
6/1/2019	3:30 PM	6/1/2019 15:30
6/1/2019	4:00 PM	6/1/2019 16:00
6/1/2019	4:30 PM	6/1/2019 16:30
6/1/2019	5:00 PM	6/1/2019 17:00
6/1/2019	5:30 PM	6/1/2019 17:30
6/1/2019	6:00 PM	6/1/2019 18:00
6/1/2019	6:30 PM	6/1/2019 18:30
6/1/2019	7:00 PM	6/1/2019 19:00
6/1/2019	7:30 PM	6/1/2019 19:30
6/1/2019	8:00 PM	6/1/2019 20:00
6/1/2019	8:30 PM	6/1/2019 20:30
6/1/2019	9:00 PM	6/1/2019 21:00
6/1/2019	9:30 PM	6/1/2019 21:30
6/1/2019	10:00 PM	6/1/2019 22:00
6/1/2019	10:30 PM	6/1/2019 22:30
6/1/2019	11:00 PM	6/1/2019 23:00
6/1/2019	11:30 PM	6/1/2019 23:30
6/2/2019	12:00 AM	6/3/2019 0:00
6/2/2019	12:30 AM	6/3/2019 0:30
6/2/2019	1:00 AM	6/3/2019 1:00
6/2/2019	1:30 AM	6/3/2019 1:30
6/2/2019	2:00 AM	6/3/2019 2:00
6/2/2019	2:30 AM	6/3/2019 2:30
6/2/2019	3:00 AM	6/3/2019 3:00
6/2/2019	3:30 AM	6/3/2019 3:30
6/2/2019	4:00 AM	6/3/2019 4:00
6/2/2019	4:30 AM	6/3/2019 4:30
6/2/2019	5:00 AM	6/3/2019 5:00
6/2/2019	5:30 AM	6/3/2019 5:30
6/2/2019	6:00 AM	6/3/2019 6:00
6/2/2019	6:30 AM	6/3/2019 6:30
6/2/2019	7:00 AM	6/3/2019 7:00
6/2/2019	7:30 AM	6/3/2019 7:30
6/2/2019	8:00 AM	6/3/2019 8:00
6/2/2019	8:30 AM	6/3/2019 8:30
6/2/2019	9:00 AM	6/3/2019 9:00
6/2/2019	9:30 AM	6/3/2019 9:30
6/2/2019	10:00 AM	6/3/2019 10:00
6/2/2019	10:30 AM	6/3/2019 10:30
6/2/2019	11:00 AM	6/3/2019 11:00
6/2/2019	11:30 AM	6/3/2019 11:30
6/2/2019	12:00 PM	6/3/2019 12:00
6/2/2019	12:30 PM	6/3/2019 12:30
6/2/2019	1:00 PM	6/3/2019 13:00
6/2/2019	1:30 PM	6/3/2019 13:30
6/2/2019	2:00 PM	6/3/2019 14:00
6/2/2019	2:30 PM	6/3/2019 14:30
6/2/2019	3:00 PM	6/3/2019 15:00
6/2/2019	3:30 PM	6/3/2019 15:30
6/2/2019	4:00 PM	6/3/2019 16:00
6/2/2019	4:30 PM	6/3/2019 16:30
6/2/2019	5:00 PM	6/3/2019 17:00
6/2/2019	5:30 PM	6/3/2019 17:30
6/2/2019	6:00 PM	6/3/2019 18:00
6/2/2019	6:30 PM	6/3/2019 18:30
6/2/2019	7:00 PM	6/3/2019 19:00
6/2/2019	7:30 PM	6/3/2019 19:30
6/2/2019	8:00 PM	6/3/2019 20:00
6/2/2019	8:30 PM	6/3/2019 20:30
6/2/2019	9:00 PM	6/3/2019 21:00
6/2/2019	9:30 PM	6/3/2019 21:30
6/2/2019	10:00 PM	6/3/2019 22:00
6/2/2019	10:30 PM	6/3/2019 22:30
6/2/2019	11:00 PM	6/3/2019 23:00
6/2/2019	11:30 PM	6/3/2019 23:30

[v-xicai]

Hi @Jorgast  ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @Jorgast ,

You can follow steps below to meet your requirement.

1.Enter a time table from 00:00 – 23:30 , rename column Time.

2.Use the formula below to create a calculate table.

DateTime =
SELECTCOLUMNS(
   CROSSJOIN (
       CALENDAR ( DATE ( 2019, 6, 1 ), TODAY()),
       'time'
   ),
   "DateTime", [Date] + [Time]
)

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.