Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Average Calculations

Hi   I need to calculate an average hours spent with customers on a monthly basis per program. What I am trying to determine is whether the average time spent with a customer is going up or down on...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks, that has worked well other than I have ran into an issue. I need to be able to filter by program and get the average hours on the program. I have tried to do this with a slicer. It changes everything bar the cumulative count of clients, which then impacts the average hours. What can I put in the measure to be able to take into account of this?

     

    For example Customers 1-4 maybe in Program A and 5-7 maybe in Program B and so on.

     

    Thanks

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Nathaniel

 

How do I get the aver[Date]? Once I type the ( after Max it wants to pick up a field from the table, if I type aver in prior I cannot pick up the date field.

 

Thanks

Kate

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

aver is my table name. Here is my pbix. aver

 

Let me know if you have more questions, 

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks, that has worked well other than I have ran into an issue. I need to be able to filter by program and get the average hours on the program. I have tried to do this with a slicer. It changes everything bar the cumulative count of clients, which then impacts the average hours. What can I put in the measure to be able to take into account of this?

     

    For example Customers 1-4 maybe in Program A and 5-7 maybe in Program B and so on.

     

    Thanks