I have two fact tables containing times that i would like to align. One query represents the tasks completed and the other query represents the employee hours and task assigned.
Right now I have the duration of time for the Picking Task query calculated via a dax measure, but I am looking to remove break times based on the Role Log query data. The time duration needs to be down to the second.
An example to reference is cluster ID 16597 (below.) This should have a 15 minute break in the middle of the time, so roughly 15 minutes should be removed based on the role log data.
There is no matching criteria to map the two queries together, so I created one to try and match them. Is my set up correct? Is what I am trying to do possible?