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