Forum Discussion
Help with calculating time ???
Hello rf27
What should the expected output be?
These are time, and having total of times doesn't seem to be of any sense to me.
To me this seems more a topic for power query rather then DAX
All the best
Jimmy
Hi Jimmy,
Thank you for your reply.
What I'm looking for is two things,
Total hours worked per date
Then Total hours per days worked .
Ex: day one- 6 hrs, day 2- 8hrs, day 3- 10hrs, and day 4- 8hrs
Total 32 hours
Hello rf27
how the start and how the end time is defined? A was not able to identify it. What I did already mention is that in one day i saw 3 times. So how to identify what is the start and what is the end date?
What would also be important to now, is what exactly is you expected output. I can think of transforming date (poviting start and end) and with this a easy measure in DAX could be created.
Jimmy
Hey Jimmy,
The first transaction , and the last transaction of the day counts for the time duration... I cut out the important piece.. I have an 1 and 0 the represents my first in and last transaction. 1 = IN 0= OUT I'm looking to tabulate the IN & OUT of every day... I hope this brings clarity to my questions..
