Urgent!! i need help in calculating the age of jira ticket in each status stage

[HibaTalat]

Hey all,
I have created a date and from that, I can calculate the age of the ticket. The idea is to see which stage is problematic and I am want to calculate in form of #days

Following is the view I want for my dashboard:

Status 1	status2	Status 3	Status 4
Fast	Fast	Fast	Fast
Slow	Slow	Slow	Slow
Average	Average	Average	Average

Fast – the least amount of time ticket
stayed in this status

Slow- the max amount of time a ticket
stayed in this status

Average – the average amount of time a
ticket stayed in this status

Please note that I am new to PBI and I am using Desktop Report Server

[Idrissshatila]

Hello @HibaTalat ,

You could start by creating a column where you get the age of the ticket using datediff function.

check this link for reference https://learn.microsoft.com/en-us/dax/datediff-function-dax

Then you create an if and else column based on the age column, where you state that if age less tha X then slow else if its greater than y then fast else average.

Refer for this link for the if & else function https://learn.microsoft.com/en-us/dax/if-function-dax

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[HibaTalat · Accepted solution]

Steps i followed 

1. In the "Fields" pane on the right side of the screen, click on the "New Column" button. created a column of date difference = datediff(table[created], today(), day)

2. Then put this on rows I placed status 

3. Values I dragged date difference and use functions to calculate avg, max and min

Please verify if it will work fine. i don't know if the procedure I followed Is correct