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

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!

 

 

 

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hi Davidolis ,
    You are very welcome! Thank you for your kind words. DAX is pretty amazing stuff.
    Nathaniel