Subtract time with offset

rosscortb@gmail.com
Posts: 1
Joined: Mon Nov 23, 2020 7:29 pm

Subtract time with offset

Postby rosscortb@gmail.com » Mon Nov 23, 2020 7:47 pm

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
Attachments
dax.xlsx
(14.33 KiB) Downloaded 12 times

User avatar
Jason Cockington
Posts: 6
Joined: Thu Jan 16, 2020 8:46 am

Re: Subtract time with offset

Postby Jason Cockington » Thu Nov 26, 2020 4:00 pm

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?
Jason Cockington is Self Service BI Trainer and Consultant with Excelerator BI


Return to “Power Query”

Who is online

Users browsing this forum: Google [Bot] and 0 guests