Forum Discussion

bhmiller89's avatar
bhmiller89
Icon for Helper V rankHelper V
7 years ago
Solved

DateDiff Between Records by Person

I have a  Date/Time for each action a person takes, but there are multiple people each with their own actions. How would I find the datediff between each record by person/date? Columns:  Date/Time...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    Hi bhmiller89 ,

     

    I created an sample as your requested, column date/time and clientID:

    You can get the datediff using below measure: (you can change the datediff function as Second/Hour/Minute)

    Measure = var a = CALCULATE(MIN([DateTime]),ALLEXCEPT('Table (2)','Table (2)'[ClientID]))
var b = CALCULATE(MAX([DateTime]),ALLEXCEPT('Table (2)','Table (2)'[ClientID]))
Return
DATEDIFF(a,b,DAY)

     

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi bhmiller89 ,

 

I created an sample as your requested, column date/time and clientID:

You can get the datediff using below measure: (you can change the datediff function as Second/Hour/Minute)

Measure = var a = CALCULATE(MIN([DateTime]),ALLEXCEPT('Table (2)','Table (2)'[ClientID]))
var b = CALCULATE(MAX([DateTime]),ALLEXCEPT('Table (2)','Table (2)'[ClientID]))
Return
DATEDIFF(a,b,DAY)