Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
I need to round current time to the start hour, but i'm working in direct query.
When i try do this on "edit query" tell me that's not supported in direct query mode.
I need to work whith direct query, i cant export all data.
It is possible to do it in another way?
Thanks!
Solved! Go to Solution.
Hi @Anonymous ,
We can create a calculated column to meet your requirement:
StartHour =
[DateTime]
- DIVIDE ( MINUTE ( [DateTime] ), 60 * 24, 0 )
- DIVIDE ( SECOND ( [DateTime] ), 3600 * 24, 0 )
Best regards,
Hi @Anonymous ,
We can create a calculated column to meet your requirement:
StartHour =
[DateTime]
- DIVIDE ( MINUTE ( [DateTime] ), 60 * 24, 0 )
- DIVIDE ( SECOND ( [DateTime] ), 3600 * 24, 0 )
Best regards,
Hi @Anonymous ,
Glad to hear that you have resolved your problem.
Best regards,
It is because time is not only in seconds.
Is it possible to round the date to seconds?
One more thing you do that with new mesure or new column?
I only can do it with a new column, but i noticed when i try to count all values they give me wrong results
I have values in the order of tens and should have in the thousands.
Try to use relationships with the calendar, but get the same results.
Thank you
Works it, thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |