Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@Joao_C_Faria , Not very clear
Hour = hour([Datetime])
Date with hour = datevalue([Datetime]) + Time(hour([Datetime]),0,0)
You helped me a lot, thank you very much!
@Joao_C_Faria , Not very clear
Hour = hour([Datetime])
Date with hour = datevalue([Datetime]) + Time(hour([Datetime]),0,0)
User | Count |
---|---|
98 | |
90 | |
83 | |
69 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |