Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count the average

Hi,   We have a ticketing system in sharepoint where each day a number of tickets will be submitted and some one in the office will resolve it and send the update (in a nutshell). I have the date ...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    I was able to get it to work with the below dax function 

    CreatDate = date(2020,03,02)
    NoOfDays = DATEDIFF([CreatDate],TODAY(),DAY)
    AverageTicketPerDay = DIVIDE(COUNT(Tickets[Id]),[NoOfDays])
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I was able to get it to work with the below dax function 

CreatDate = date(2020,03,02)
NoOfDays = DATEDIFF([CreatDate],TODAY(),DAY)
AverageTicketPerDay = DIVIDE(COUNT(Tickets[Id]),[NoOfDays])