Forum Discussion

e175429's avatar
e175429
Icon for Helper IV rankHelper IV
1 year ago
Solved

Transferring time format to BI

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 t...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
1 year ago

e175429 

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

 

e175429's avatar
e175429
Icon for Helper IV rankHelper IV
1 year ago

When I change the type, I get this:

There is no 12th hr and there is no AM

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.