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.
Hi everyone! Wish you all have a very nice day!
Based on the image above, i have TimeIn & TimeOut. So i try to get the hours between these 2 times, meaning that TimeOut - TimeIn. So based on that simple calculation, i got the hours worked values. But some of the value have -ve sign. I just want to know how many hours worked & i just want to ignore the -ve values. So how can i do that? Thanks in advance 😊
Solved! Go to Solution.
@New_be Try this:
Number.Abs(Number.From([Adj_OutTime]) - Number.From([Adj_InTime])) * 24
@New_be , I think because the out time in on next day
if Duration.Hours([Adj_hour_worked]) <0 then [Adj_hour_worked] + duration(1,0,0) else [Adj_hour_worked]
@New_be , If you have use hour(Adj_hourworked_temp) < 0 and try
or Adj_hourworked_temp <#duration(0,0,0,0)
Indeed! It is because the out time is in the next day & vice versa. Thanks!
@New_be , In case of the issue, is resolved. Accept all suitable solutions for others to get a similar solution.
@New_be - Use Number.Abs to get the absolute value. So formula should be:
Number.Abs([Adj_OutTime] - [Adj_InTime])
I try to use this formula;
But i got the error;
@New_be Try this:
Number.Abs(Number.From([Adj_OutTime]) - Number.From([Adj_InTime])) * 24
@New_be - Cool. Sometimes Power Query really annoys the **bleep** out of me!! 🙂
@New_be Maybe try some spaces? This worked for me
Number.Abs([SampleID] - [Outcome]) * 24
Oh, wait, those are date time, hang on.
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 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |