Forum Discussion

WoutD's avatar
WoutD
New Member
8 years ago
Solved

Datetime: 24h format

Hi everyone,   I just started working with powerbi desktop, so don't shoot me if I say anything stupid. Searched the forum for possible matches to my problem, but can't seem to find anything that ...
  • jdobrzen's avatar
    jdobrzen
    8 years ago

    It looks like a 24hour isnt available by default, so you can create a calculated column and use the following DAX to achive the time format. The capital "HH" give you the double digit 24hr.

     

    24hr = FORMAT(ReportData[ImportDate],"HH:mm:ss")

     

    https://msdn.microsoft.com/en-us/library/ee634398.aspx

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

WoutD,

You can click on your column in the Fields pane, select Modeling ribbon on top, and go to Format section to find the format you  want for your date. If you could not find it, it means that Power BI does not support this format by default, hence you might have to write some DAX to format your date.