Forum Discussion
Duration between statuses
Good day All, I have a bit of a conundrum. I have data as per below I would like to calculate the duration that a specific "issue_id" has spent in a status (from_string and to_string...
Hi Anonymous
Not sure if I'm missing something, but I can't see "from_status" and "to_status". Also, can you share your sample file with expected solution so I can try to help with the solution.
Hi AnkitKukreja,
Sorry about the Typo, it should have been "from_string" and "to_string". I am not sure how to share files on here.
Below is a better example with possible outcomes I am looking for. The "Duration_Days" column I already managed to add in Power Query and calculates correctly. Whether this is the correct way or not I am not sure.