Forum Discussion
Solved
Date table including Interval
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 inte...
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.
