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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

You can go to the Query editor ("Transform data"), then the "Add column" tab, then "Time" in the panel "From date & time":