Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Backlog age per day

Hello all!

I need your help to find a solution for this matter. The idea is to calculate the average age of the tickets from my backlog per day. The average age must be in days (not in minutes or hours). Let me give you an example.

TICKET NUMBERCREATION DATEEND DATE
4050001/03/2019 8:4504/03/2019 10:00
4050102/03/2019 10:3005/03/2019 11:00
4050203/03/2019 12:0506/03/2019 17:00
4050304/03/2019 16:5706/03/2019 16:00

 

This an example of a ticket table. I need to calculate de age of each tickets taking a date as a reference (DATE column).

 

  TICKET Age per day
DATEAVERAGE BACKLOG AGE40500405014050240503
02/03/2019 0:000,6354166670,6354   
03/03/2019 0:001,0989583331,63540,5625  
04/03/2019 0:001,029513889 1,56250,4965 
05/03/2019 0:001,450925926 2,56251,49650,2937

 

I need to obtain a formula to do the same calculus as I have in AVERAGE BACKLOG AGE column.

 

Maybe a temporal table would be the solution (I have one for the calculus of the number of tickets of backlog per day), but in this case I need to calculate the average age of the tickets from the backlog per day.

 

Any ideas? Thanks for your help as always :)

Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    How did you get the TICKET Age here? Is that the data from fact table or not?

     

    Regards,

    Frank

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-frfei-msft 

      The calculus on that table is built in Excel, not in Power BI. That's an example of what I need to calculate in PBI.