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.

 

  • Joao_C_Faria , Not very clear

     

    Hour = hour([Datetime])

     

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

     

     

2 Replies