Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Average lead time

Hello all,   I'm trying to figure out how to show my average lead time, changeable with whatever the user selects as filter (year, type of ticket, drill down deeper into a year for months etc.) as ...
Need Help
Show and Tell
Tutorial Requests
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    Using your oringinal data "Seconds" for calculation would be better.

    Create 2 measures as below:

    average = AVERAGEX(ALLSELECTED('Table'),'Table'[Seconds])
    format = 
var _hour=INT('Table'[average]/3600)
var _min=INT(DIVIDE('Table'[average]-_hour*3600,60))
var _sec=INT('Table'[average]-_hour*3600-_min*60)
Return
_hour&":"&_min&":"&_sec

    And you would see:

    For my related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Wow! Thanks a lot! I can't thank you enough, this saved such a headache. Thank you for the expert help.

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi  Anonymous,

 

It's my pleasure.🙂

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!