Extract time from date using measure

[davehardikkumar]

Is it possible to exteact time from date by uisng measure?

[tamerj1]

@davehardikkumar 

If the column has a DateTime data type then you can use

TIMEVALUE ( 'Table'[DateTime] )

[davehardikkumar]

unfortunately I have to use ssas module. so cant add/update column.

[tamerj1]

@davehardikkumar 

can you create or add tables?

[davehardikkumar]

Yes I can using measure

[davehardikkumar]

id  date                                              hour

1   Mon, 13 Mar 2023 23:59:41

2   Mon, 14 Mar 2023 22:51:40

3   Mon, 15 Mar 2023 21:52:20

If I use above measure it gives me the max date. above is my table and i want to add measure in that table and display hour. how can I achieve that?

[Greg_Deckler]

@davehardikkumar Yes:

Time Measure = 
  VAR __DateTime = MAX('Table'[DateTime])
  VAR __Result = __DateTime - TRUNC(__DateTime)
RETURN
  __Result

[davehardikkumar]

I want to use that seperated hours measure as slicer. How can I achieve that?

Thanks for your help!