Hello,
I have two job requisitions and shows the approval time for each stage. I need to work out the time in dd/hh/mm between each stage using query/dax. The issue I am having is that each stage is in the same column one row above.
I have attached a sample if anyone can help please?
Regards
Ross
Subtract time with offset
-
rosscortb@gmail.com
- Posts: 1
- Joined: Mon Nov 23, 2020 7:29 pm
Subtract time with offset
- Attachments
-
- dax.xlsx
- (14.33 KiB) Downloaded 12 times
-
Jason Cockington
- Posts: 6
- Joined: Thu Jan 16, 2020 8:46 am
Re: Subtract time with offset
Hi Ross,
I am trying to understand your problem, but your description doesn't match your sample data.
Are there just two requisition times, Row 1 & 5, and then rows 2-4 need to compare time elapsed since row 1, and 6-10 needs to compare time elapsed since row 5?
I am trying to understand your problem, but your description doesn't match your sample data.
Are there just two requisition times, Row 1 & 5, and then rows 2-4 need to compare time elapsed since row 1, and 6-10 needs to compare time elapsed since row 5?
Jason Cockington is Self Service BI Trainer and Consultant with Excelerator BI
Who is online
Users browsing this forum: Google [Bot] and 0 guests