Forum Discussion

RobertReeves's avatar
RobertReeves
Frequent Visitor
3 years ago
Solved

Create a time frame column from a datetime column

I have a table that has start and end times for calls. I need to create a column that has a time frame that the call took place in.  Is this possible in Power BI desktop? Below example has it split b...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi RobertReeves ,

     

    I think you can try this code to create a calculated column.

    Time Frame = TIME(HOUR('Table'[StartTime]),00,00)

    Change the data type to Time. Result is as below.

     

    Best Regards,
    Rico Zhou

     

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi RobertReeves ,

 

I think you can try this code to create a calculated column.

Time Frame = TIME(HOUR('Table'[StartTime]),00,00)

Change the data type to Time. Result is as below.

 

Best Regards,
Rico Zhou

 

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