Forum Discussion
Visual showing average time
Hello all, I am trying to show by month what the average time a client is seen.. my data has the following columns, Attendance ID (Unique), Name, Attend_DateTime,Attend_MonthYear,Seen_DateTim...
Hi Mo,
please upload on wetransfer.com the excel data and i'll will happy to help you and explain all the passage.
Another question: the average that you are looking for is the difference between seen - attend?
If is this is not very difficult.
- Create a calculated column that is the difference with datediff (seen, attend, second) https://learn.microsoft.com/en-us/dax/datediff-function-dax
- the put on the visual the calculated column and on the field you put in the visual select the arrow and show the AVERAGE.
Alternative create a MEASURE that is
MAESURE = AVERAGE(CalculatedColumn)
and put the Measure into the visual.
I hope I have been helpful.
Mark it as a solution if resolve your problem.
Ciao!