Need Help!! Jira lifecycle

[HibaTalat]

Hey Champs,

I am getting data from Jira to PBI report server. I want to calculate the time when a ticket leaves a status.

I have the following columns:

Issue ID

Timestamp (when the issue moves from 1 status to another)

Status to (status it moved)

Status from (Status from where it moved)

I cannot find the DAX formule or power bi . just need a column.

[HibaTalat]

i have resolved it using indexes and merges.