Convert DateTime format from dd/mm/yyyy hh:mm:ss to dd/mm/yyyy hh

[PoojaG]

Please let me know how to convert a DateTime format from dd/mm/yyyy hh:mm:ss to dd/mm/yyyy hh in Power editor.

For example 01/01/2019 02:12:34 to 01/01/2019 02:00:00.

[Riantilo · Accepted solution]

Edit: [start_time] is a DateTime column

Its not in the default transform options. I did accomplish this once using Power Query. It isn't pretty but it works.

I created a Custom Column with the following formula:
Text.From(Date.Day([start_time]))
&"/"&
Text.From(Date.Month([start_time]))
&"/"&
Text.From(Date.Year([start_time]))
&" "&
Text.From(Time.Hour(DateTime.Time([start_time])))
&":00:00"

After that select data type of the column and set it to Date/Time.

Gr,

Jesse

[Anonymous]

I don't believe that is a default option but this can be solved in DAX

=FORMAT(<value>, "dd/mm/yyyy hh")