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 Shas...
General Comment
Need Help
Show and Tell
Tips and Tricks
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

    • v-lid-msft's avatar
      v-lid-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi Anonymous ,

       

      If you hake a pm/am in the end of your date, it will be recognized as 12 hours Format just like the following picture.

       

       

      But in your sample, power query editor does not know if it is am or pm so it will recognized as 24 hours Format i think.

       

      Best regards,

       

      Community Support Team _ DongLi
      If this post helps, then please consider Accept it as the solution to help the other members find it more

  • 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.