Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Date Time Format 12 hours to 24 hours Format

Hi Team,

 

Need help on Date  time format conversions . i have date with time 12 hours formats .

how can i convert into 24 hours format . Any lead will appericate Thanks in advance 

Regards

Shashanka chhanda 

General Comment
Need Help
Show and Tell
Tips and Tricks

7 Replies

  • PradipMCT's avatar
    PradipMCT
    Icon for Resolver II rankResolver II
    7 years ago

    Hi Anonymous 

     

    can you share your data file? As on my computer it's happening perfectly. I just changed the data type to Time. 

     

    Regards,

    Pradip Microsoft Certified Trainer

    Pradip's YouTube Channel

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello I have Date Format like 07/09/2019 02:05 . I want in format like 07/09/2019 14:05.

      Can you please write the Dax for this

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

    That should be a simple format change in the Query Editor.  If it does not work, then show your data and the expected result.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello i have Date Format like 07/09/2019 02: 05.

      I want format like 07/09/2019 14:05 .

      Can you please write the Dax for this .

      Thanks in advance.

      • PradipMCT's avatar
        PradipMCT
        Icon for Resolver II rankResolver II
        7 years ago

        Hi Anonymous ,

         

        I don't think this needs DAX function. You just need to go to the power query editor and set the data type to Date/Time. Once that is done if the dates are right it will automatically convert them to 24 hours format. 

         

        If this doesn't solve your problem then it could be the problem with the data itself. Please share the data so that I can study it and provide the solution accordingly.

         

        Regards,

        Pradip Microsoft Certified Trainer

        Pradip's YouTube Channel

    • hamzabhatti's avatar
      hamzabhatti
      Regular Visitor
      6 years ago

      I am working on streaming datatset . Now i want to change format into last 24 hours and last 7 days record with day names..But all options are available in non streaming datset e-g excel files . can you please help me because i have to publish file without measure according to powerbi limitations to avail the option of piblish to web.