Forum Discussion

AaronRogers3's avatar
AaronRogers3
Helper I
8 years ago
Solved

Average Time per Item Code

I am currently successfully getting the average times as a whole using this DAX formula for example:

Average Cleaning Time = FORMAT(AVERAGE(RECORDS_TABLE[CLEANING_TIME]),"HH:MM:SS")

For each of my records in my table  there is an ITEM CODE. So there is set-up, processing, reconciliation, cleaning and total time associated against Item codes.

 

I have been asked to visualisations which shows the Average Times per Item Code.

 

Does anyone know how i can achieve this? the times are in HH:MM:SS format.

 

Thanks!

Need Help
Show and Tell
  • v-danhe-msft's avatar
    v-danhe-msft
    8 years ago

    Hi AaronRogers3,

    Based on my test, you could refer to below steps:

    1.I have entered some sample data:

    2.Create a new measure and a Table visual and now you could get the average times for per Item Code.

    A = var t = SUMMARIZE('Sheet3',Sheet3[ID],"avgtime",FORMAT(AVERAGE(Sheet3[Cleaningtime]),"HH:MM:SS"))

    return MAXX(t,[avgtime])

    If I misunderstood you, could you please offer me more information about your data structure or share your pbix file if possible?

     

    You can also download the PBIX file to have a view.

    https://www.dropbox.com/s/zj2u6ngxer3yica/Average%20Time%20per%20Item%20Code.pbix?dl=0

     

    Regards,

    Daniel He

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    8 years ago

    Hi AaronRogers3,

    Based on my test, you could refer to below steps:

    1.I have entered some sample data:

    2.Create a new measure and a Table visual and now you could get the average times for per Item Code.

    A = var t = SUMMARIZE('Sheet3',Sheet3[ID],"avgtime",FORMAT(AVERAGE(Sheet3[Cleaningtime]),"HH:MM:SS"))

    return MAXX(t,[avgtime])

    If I misunderstood you, could you please offer me more information about your data structure or share your pbix file if possible?

     

    You can also download the PBIX file to have a view.

    https://www.dropbox.com/s/zj2u6ngxer3yica/Average%20Time%20per%20Item%20Code.pbix?dl=0

     

    Regards,

    Daniel He