Backlog average age by day
Hi, I need to calculate the average age of active tickets relatively to each day in my calendar table on the X axis. The way it is calculated is by adding +1 for each day where the ticket isn't solved (between start and end dates) and where the status is 0. Then the average is calculated on active tickets by date. Below an example of what I am trying to achieve : My datamodel is as follow : Thanks for the help.Open, close and backlog tickets
I have these 2 tables that are connected through timeID, I need to create a dax for Open, Close and Backlog incidents on monthly basis for example in the month of may count the number of incidents that are open and have open date started in May, No of tickets closed in May and No of backlog tickets that were opened before May and are still open in May. I have a month slicer and my chart should show open, close and backlog tickets versus months on x axis.
