Forum Discussion
Average
So I am trying to show average handle time per day with bars and the average of the month with a line. So I wrote a dax fuction but when I want to see the day by day it ended being the quantity of th...
Hi Anonymous
Try the below measure
Calculate(AVERAGE(Base[duracion_minuto]), allexcept(Base,FORMAT(Base[date],"YYYY-MM")))or
Post the sample data
Hi Anonymous
Use the line and clustered column chart and put handle time in the line values section select average as shown below.
Anonymous i am usi g average gor the bars so i can ser the daily average but u Wanna compare the daily average with the monthly average
Hi Anonymous
Try the below measure
Calculate(AVERAGE(Base[duracion_minuto]), allexcept(Base,FORMAT(Base[date],"YYYY-MM")))or
Post the sample data
Anonymous I had to check allexcept and I used on my calendar table and it worked! thanks!!