average per day
2 Topics
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.Solved2.4KViews0likes14Comments
Need help with DAX Measure for Average Per Day
Hello, I've been working in Power BI only a few months.. I am trying to create a matrix that shows the average number of good leads by Inventory Product Type, placement type and then columns are filtered on certain months. There are currently hundreds of rows for each product/placement type. I've attached a sample spreadsheet. I can get the "average" # of the good leads, but not the average per day. The months are the previous year month, then the last two months, as well as the current month to date. Currently, we show the average of the last three current months (past two + mtd), and then compare the current mtd to the average to see the percentage off from the average. We will probably lose the MTD information for YoY and MoM visuals, but I still need to know how to get the average per day. Are there any other measures I need to ceate? I did create a number of days in the month measure to use but I can't seem to select it in a divide function. You guys are great so thanks in advance for any guidance you can provide. I've attached the sample data here: Average Good Leads Per Day Placement 2023-06 2024-05 2024-06 2024-07 MTD AVG % off Prod Type 1 2.23 7.16 7.80 6.70 7.22 -7.25% Dealer 0.30 0.77 0.37 0.35 0.50 -29.91% Listing 1.10 2.23 3.20 2.39 2.61 -8.23% Misc 0.07 0.03 - - 0.01 -100.00% Website 0.77 4.13 4.23 3.96 4.11 -3.65% Prod Type 2 0.23 1.29 1.47 1.87 1.54 21.23% Listing - 0.26 0.23 0.39 0.29 32.99% Website 0.23 1.03 1.23 1.48 1.25 18.46% Prod Type 3 0.43 9.45 12.37 8.61 10.14 -15.12% Deaer - 0.06 0.03 - 0.03 -100.00% Listing 0.30 5.77 7.03 4.30 5.70 -24.54% Misc - - - - - 0.00% Website 0.13 3.61 5.30 4.30 4.41 -2.30% TOTAL 2.90 17.90 21.63 17.17 18.90 -9.15%Solved2KViews0likes6Comments
