Forum Discussion
Average Daily Volume within Date Range
Hello,
Looking to display average ticket volume from Date A to Date B on a card. The date range will be static and used as a reference to new volume after Date B.
My data structure:
Ticket ID, Create Date...
Desired result:
Average Daily volume Created between June 1 - July 26 = 150 tickets daily.
I think it should be simple, but I am not finding info specific to my needs for this Measure.
Trying to follow this Measure formula (and change SUM to AVERAGE), but having difficulty understanding syntax - autocomplete is not helping me specify the ticket field in the table.
Static_Dates_Between = CALCULATE(SUM(TransactionData[Revenue]),
DATESBETWEEN(CalenderDate[Date],DATE(2016,01,01),DATE(2017,12,31)))
2 Replies
Try this generic pattern ( wrote from my phone so it is untested 😞
Average_Daily_Ticket_Volume =
VAR DateA = DATE(2023, 6, 1) // Replace with your actual Date A
VAR DateB = DATE(2023, 7, 26) // Replace with your actual Date B
VAR NumDays = MAX(DATEDIFF(DateA, DateB, DAY)) + 1
RETURN
DIVIDE(
CALCULATE(COUNTROWS('YourTableName'), 'YourTableName'[Create Date] >= DateA && 'YourTableName'[Create Date] <= DateB),
NumDays
)Replace 'YourTableName' with the actual name of your table that contains the "Ticket ID" and "Create Date" columns. With this measure, you can now place a card visual in your report, and in the "Values" field, select the "Average_Daily_Ticket_Volume" measure. It will show the desired result of the average daily ticket volume between the static date range of June 1 to July 26.
