Forum Discussion

Joao_C_Faria's avatar
Joao_C_Faria
Helper I
4 years ago
Solved

breack text

Good afternoon, I have a column with data and time, I need a column with hours, but as this column is a dax formula, I can't open it in the power query, is there a solution? Thanks.  
  • amitchandak's avatar
    4 years ago

    Joao_C_Faria , Not very clear

     

    Hour = hour([Datetime])

     

    Date with hour = datevalue([Datetime]) + Time(hour([Datetime]),0,0)