Get Time from DateTime field

[Thankyouverymuc]

Dear Power BI community, 

Can anyone please help me with a DAX formula with extracting the time value from a datetime field.

See for example the below datetime values and I want to extract the timevalue from the datetime field

So for the output, I would like to see 11:17:56 or 3:00:00 in a new column - I want to keep the current column which shows datetime and add a new column with the correct formula. 

Can anyone please help me? 

Thank you guys! 

[tackytechtom · Accepted solution]

Hi @Thankyouverymuc ,

Here a solution for a calculated column as described in this blog post as well:
https://www.tackytech.blog/how-to-crack-the-mystery-of-the-mighty-dax/#22_How_to_retrieve_the_time_f...

We start by duplicating the datetime column:

--> Right click on a column in your table and select new column:

--> duplicate the column by referencing the datetime column:

NewColumn = TableDateTime[DateTime]

Then, just change the format to Time (just like @Syk  suggested in Power Query):

The result:

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Thankyouverymuc]

Hi Guys! Thank you both for your quick responses but I can't work through the Power Query because I don't have the rights yet so could you please give me a solution with a DAX formula? In Excel, there are various ways through which I can convert it but somehow I can't find it with DAX.

[tackytechtom]

Hi @Thankyouverymuc ,

One way to achieve this is by using Power Query:

Just add a new column with the following code:

= Time.From([DateTime])

Let me know, if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Syk]

Right click on column and hit duplicate
Then click on the new column and go to transform > Time > Time only