Forum Discussion
Joao_C_Faria
4 years agoHelper I
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.
- 4 years ago
Joao_C_Faria , Not very clear
Hour = hour([Datetime])
Date with hour = datevalue([Datetime]) + Time(hour([Datetime]),0,0)
amitchandak
4 years agoSuper User
Joao_C_Faria , Not very clear
Hour = hour([Datetime])
Date with hour = datevalue([Datetime]) + Time(hour([Datetime]),0,0)