Forum Discussion

ConnieMaldonado's avatar
ConnieMaldonado
Responsive Resident
5 years ago
Solved

Calculate Service for Distinct Techs

Hello - I'm trying to calculate the average service for technicians trained by specific trainers.  My data looks like this:   Date Tech Name Tech Hire Date Tech Employee Number Trainer EE Nu...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    ConnieMaldonado , You can have measure like this

    sumx(summarize(Table, Table[Tech Name],[Tech Hire Date]), datediff([Tech Hire Date], today(),DAY)/30)

    You can have

    Averagex(summarize(Table, Table[Tech Name],[Tech Hire Date]), datediff([Tech Hire Date], today(),DAY)/30)

     

    or use min of hire date

    sumx(summarize(Table, Table[Tech Name], "_TechHireDate",Min([Tech Hire Date])), datediff([_TechHireDate], today(),DAY)/30)

amitchandak's avatar
amitchandak
Super User
5 years ago

ConnieMaldonado , You can have measure like this

sumx(summarize(Table, Table[Tech Name],[Tech Hire Date]), datediff([Tech Hire Date], today(),DAY)/30)

You can have

Averagex(summarize(Table, Table[Tech Name],[Tech Hire Date]), datediff([Tech Hire Date], today(),DAY)/30)

 

or use min of hire date

sumx(summarize(Table, Table[Tech Name], "_TechHireDate",Min([Tech Hire Date])), datediff([_TechHireDate], today(),DAY)/30)

ConnieMaldonado's avatar
ConnieMaldonado
Responsive Resident
5 years ago

Awesome!  Thank you.