https://community.fabric.microsoft.com/t5/Report-Server/Need-Help-Jira-lifecycle/m-p/3125723#M29148 <P>i have resolved it using indexes and merges.&nbsp;</P> Sat, 11 Mar 2023 22:08:23 GMT HibaTalat 2023-03-11T22:08:23Z https://community.fabric.microsoft.com/t5/Report-Server/Need-Help-Jira-lifecycle/m-p/3107132#M29070 <P>Hey Champs,</P><P>I am getting data from Jira to PBI report server. I want to calculate the time when a ticket leaves a status.</P><P>&nbsp;</P><P>I have the following columns:</P><P>Issue ID</P><P>Timestamp (when the issue moves from 1 status to another)</P><P>Status to (status it moved)</P><P>Status from (Status from where it moved)</P><P>&nbsp;</P><P>I cannot find the DAX formule or power bi . just need a column.</P> Thu, 02 Mar 2023 05:31:11 GMT https://community.fabric.microsoft.com/t5/Report-Server/Need-Help-Jira-lifecycle/m-p/3107132#M29070 HibaTalat 2023-03-02T05:31:11Z https://community.fabric.microsoft.com/t5/Report-Server/Need-Help-Jira-lifecycle/m-p/3125723#M29148 <P>i have resolved it using indexes and merges.&nbsp;</P> Sat, 11 Mar 2023 22:08:23 GMT https://community.fabric.microsoft.com/t5/Report-Server/Need-Help-Jira-lifecycle/m-p/3125723#M29148 HibaTalat 2023-03-11T22:08:23Z