Forum Discussion

Jorgast's avatar
Jorgast
Resolver II
7 years ago
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...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    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.

v-xicai's avatar
v-xicai
Community Support
7 years ago

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.