Calculating elapsed time over different rows depending on status and claim number

[DannyVickery]

Hi all,

I am a bit stuck, i want to calculate elapsed time between "Submitted" and "Approved by Hub" status.

They are over different rows liked by the claim #

Any help would be really apreciated

Thanks in advance 

[Eric_Zhang · Accepted solution]

---

@DannyVickery wrote:

Hi all,

I am a bit stuck, i want to calculate elapsed time between "Submitted" and "Approved by Hub" status.

They are over different rows liked by the claim #

Any help would be really apreciated

Thanks in advance 

---

@DannyVickery

You can try to create measures like 

submitted time =
MAXX (
    FILTER ( 'Table', 'Table'[New_Status_c] = "SUBMITTED" ),
    'Table'[Change_date_c]
)


approved time =
MAXX (
    FILTER ( 'Table', 'Table'[New_Status_c] = "APPROVED BY HUB" ),
    'Table'[Change_date_c]
)

elapsed hours = DATEDIFF([submitted time],[approved time],MINUTE)/60