Transferring time format to BI

[e175429]

Hello all,

This is my data in excel:

When I birng it in to BI, it changes it to this:

I can't uoload the BI file because I have to be a SuperUser (shame).

How do I get it back to the correct format?

The ultimate goal is to calculate the overtime wait and service time by year.

Thank you!

[Fowmy]

@e175429 

Change the Data Type to Time, right click on the column > Chagne Type > Time

[e175429]

When I change the type, I get this:

There is no 12th hr and there is no AM

[Anonymous · Accepted solution]

Thanks for the reply from Fowmy , please allow me to provide another insight:

Hi, @e175429 
Thanks for reaching out to the Microsoft fabric community forum.

I believe your requirement might be better met by converting the data type to Duration.

Here is a screenshot of the relevant documentation:

Secondly, your Month and Year columns are not in date format. I suggest you combine these two columns and then change the data type to date. This will make it easier for you to handle the issue using DAX.

For more details, please refer to the relevant documentation:

Data types in Power BI Desktop - Power BI | Microsoft Learn

Auto date/time in Power BI Desktop - Power BI | Microsoft Learn
Time intelligence functions (DAX) - DAX | Microsoft Learn
 

I hope these suggestions are helpful to you. If you have any questions or need further assistance, please feel free to let me know!

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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