breack text

[Joao_C_Faria]

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]

You helped me a lot, thank you very much!

[amitchandak · Accepted solution]

@Joao_C_Faria , Not very clear

Hour = hour([Datetime])

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