Forum Discussion
davehardikkumar
Helper I
3 years agoExtract time from date using measure
Is it possible to exteact time from date by uisng measure?
7 Replies
- Greg_Deckler
Community Champion
davehardikkumar Yes:
Time Measure = VAR __DateTime = MAX('Table'[DateTime]) VAR __Result = __DateTime - TRUNC(__DateTime) RETURN __Result- davehardikkumar
Helper I
I want to use that seperated hours measure as slicer. How can I achieve that?
Thanks for your help!
- davehardikkumar
Helper I
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?
- tamerj1
Community Champion
If the column has a DateTime data type then you can use
TIMEVALUE ( 'Table'[DateTime] )
- davehardikkumar
Helper I
unfortunately I have to use ssas module. so cant add/update column.
- tamerj1
Community Champion
can you create or add tables?