Forum Discussion

davehardikkumar's avatar
davehardikkumar
Icon for Helper I rankHelper I
3 years ago

Extract time from date using measure

Is it possible to exteact time from date by uisng measure?
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

davehardikkumar Yes:

Time Measure = 
  VAR __DateTime = MAX('Table'[DateTime])
  VAR __Result = __DateTime - TRUNC(__DateTime)
RETURN
  __Result
  • davehardikkumar's avatar
    davehardikkumar
    Icon for Helper I rankHelper I
    3 years ago

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

     

    Thanks for your help!