Forum Discussion

Mo2504's avatar
Mo2504
New Member
3 years ago

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_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

 

Need Help
Tutorial Requests

1 Reply

  • lucadelicio's avatar
    lucadelicio
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    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!