Forum Discussion

AI14's avatar
AI14
Icon for Helper III rankHelper III
3 years ago
Solved

distinct values from date/time column

Hi,   What formula or technique can i use to only return distinct time values from a date/time column. the column shows start of hour ( possible times: 04:00 - 23:00) however i use a date slicer w...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi AI14 
    Create a time only column like TIMEVALUE ( 'Table'[DateTime] ) then use it in the x-axis of the chart

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi AI14 
Create a time only column like TIMEVALUE ( 'Table'[DateTime] ) then use it in the x-axis of the chart