topic Re: Extract time from date using measure in DAX Commands and Tips

Extract time from date using measure

davehardikkumar — Tue, 04 Apr 2023 14:40:50 GMT

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

Greg_Deckler — Tue, 04 Apr 2023 14:43:36 GMT

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

davehardikkumar — Tue, 04 Apr 2023 14:50:01 GMT

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 — Tue, 04 Apr 2023 15:38:29 GMT

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

TIMEVALUE ( 'Table'[DateTime] )

davehardikkumar — Tue, 04 Apr 2023 19:06:47 GMT

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

Thanks for your help!

davehardikkumar — Tue, 04 Apr 2023 19:08:27 GMT

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

tamerj1 — Tue, 04 Apr 2023 19:36:28 GMT

can you create or add tables?

davehardikkumar — Tue, 04 Apr 2023 19:45:40 GMT

Yes I can using measure