Visual showing average time

[Mo2504]

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_DateTime

what i want to display is something like this:

Im New to power Bi so will need a step by step guide please.. everything i have searched for makes no sense

thanks in advance

[lucadelicio]

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!