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
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |