Forum Discussion
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 ...
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
Thanks everyone for the fast response. This works, although I still don't understand why powerBI converts the time in the first place...
Well... it's sorted out, so I'm happy.