Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.


Extract time from date using measure

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

Super User
Super User


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

TIMEVALUE ( 'Table'[DateTime] )

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


can you create or add tables?

Yes I can using measure


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?

Super User
Super User

@davehardikkumar Yes:

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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


Thanks for your help!

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors