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.
Hello, colleagues, I ask you, I have to calculate the number of hours between, start time and end time and when power bi meets this example
start time end time number of hours consumed
11.30 pm 12.00 am -23
He solves it by giving me a negative -23 instead of 0.5 hours
I have the problem with that schedule, the rest works fine
I appreciate your help
Juan Cruz
Solved! Go to Solution.
Hi @JuanCruz
A day runs from 12:00AM to 11:59 PM.
You need to explicitly state the date for this to work as you expect. Without any date component, PBI takes the date for these times to be 30 Dec 1899 and 12.00AM to be midnight at the start of that day, not the next midnight that comes after 11.30pm.
Regards
Phil
Proud to be a Super User!
Hi @JuanCruz
A day runs from 12:00AM to 11:59 PM.
You need to explicitly state the date for this to work as you expect. Without any date component, PBI takes the date for these times to be 30 Dec 1899 and 12.00AM to be midnight at the start of that day, not the next midnight that comes after 11.30pm.
Regards
Phil
Proud to be a Super User!
Thanks, Phil, i am going to propose to the user to see if it convinces him
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 |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |