DateTime Conversion

[breitgo]

Dear all,

maybe you can point me to the right answer:

In an import file I have a column with date-time data. Format is YYYYMMDDHHMM (as text). E.g. 201801031403

My challenges:

I need two columns - one with data, one with time - which I later can use for filter & navigation

• Column split did work (split after the 8th digit "20180103")
• Formatted date column as date - worked as well
• 2nd column is the time column - here the formatting does not work at all. 

What am I doing wrong??? Or is there any smarter solution?

Cheers

Christian

[Anonymous]

Hi Christian,

Data Type : Time has specific formats.

Hour, Minutes and Seconds are seperated my colon.

So, I suggest split 2nd column after 2nd digit so it gives you seperate Hour and Minute values. Add custom column to concatenate them with colon in between Or merge columns using colon seperator. Change Data Type to Time.

[v-yuezhe-msft · Accepted solution]

@breitgo,

Please check detailed steps in the PBIX file below about how to get time part from the column and convert it to Time.

https://1drv.ms/u/s!AhsotbnGu1NolB_GPuXRV5NCay0r


Regards,
Lydia