Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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 |
Solved! Go to 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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |