Forum Discussion

Davidolis's avatar
Davidolis
Regular Visitor
6 years ago
Solved

Find time between entries in same column

Hi,   I have a table which has 2 columns. One column (number) represents units with serial numbers that are unique. The other column (date - day) is which date the serial numbers are entered.   E...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Davidolis , amitchandak ,
    The last column is the average overall.

    AverageX = AVERAGEX(serialN,IF(serialN[Datediff]=BLANK() && serialN[Average time]>0,serialN[Average time]))

     

    which will also work as a measure.

     


    Let me know if you have any questions.

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

  • Davidolis's avatar
    Davidolis
    Regular Visitor
    6 years ago

    Hi, sorry if it wasn't clear i will make an example

     

    1234567891.1.2018
    9876543212.5.2019
    1245789455.5.2018
    1234567894.5.2019
    5541234796.6.2019
    98765432110.11.2019
    1234567899.11.2019

     

    An entry can show up multiple times and I need to know how long on average between each entry and then average for all. Is this helpful? I haven't attempted the proposed solutions yet, just thought i would do my part first.

    • Nathaniel_C's avatar
      Nathaniel_C
      Community Champion
      6 years ago

      Hi Davidolis , amitchandak ,
      The last column is the average overall.

      AverageX = AVERAGEX(serialN,IF(serialN[Datediff]=BLANK() && serialN[Average time]>0,serialN[Average time]))

       

      which will also work as a measure.

       


      Let me know if you have any questions.

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

      • Davidolis's avatar
        Davidolis
        Regular Visitor
        6 years ago

        Nathaniel_C This is great, Thank you so much! 

         

        I had some problems getting the last one to work, but it needed a ; instead of a, in the last parameter for the IF. 

         

        Thank you so much for helping me out! The examples really let me walk through it and understand how to do it. Without that table i would not have been able to recreate it...😕 Thanks again Nathan!