Forum Discussion

nhol's avatar
nhol
Advocate II
8 years ago
Solved

Seperate Time from Date

I have a [Date] column which includes Date and Time. I would like to extract the time to have it in a seperate column as well as the date BUT Still keeping the original [Date] column. I created a c...
Data Modeling
  • nhol's avatar
    nhol
    8 years ago

    Thanks so much!

    That helped although I was not able to use it in a visual because it can not accept a measure as Axis.

    I think I should go ahead and add another field in the database.

     

    Best,

    NH

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi nhol,

 

As you are using DirectQuery mode, please create a measure rather than calculated column. To make sure Format() function works, please enable below option: 

 

 

Measure = FORMAT(MAX([CreateTime]),"hh:mm:ss")

 

 

Or, assume you connect to SQL Server database, you can write T-SQL query to get data: 

 

 

 

Best Regards,
Qiuyun Yu

nhol's avatar
nhol
Advocate II
8 years ago

Thanks so much!

That helped although I was not able to use it in a visual because it can not accept a measure as Axis.

I think I should go ahead and add another field in the database.

 

Best,

NH