Based on Datetime difference between current row and previous row, display an alert in dashboard

[Anonymous]

Hi Everyone,

I need to get datetime difference between current row and previous row.

Eg: 2nd row - 1st row, 3rd row - 2nd row, 4th row - 3rd row and so on

If the time difference is greater than 10 mins, It need to show an alert in the dashboard like a pop up or in card. My datetime column looks like

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may add an index column in query editor.Then you may create below measures to filter the table visual to pop up the value.For further,please refer to attached file.

Previous_DateTime =
CALCULATE (
    SUM ( Table2[DateTime] ),
    FILTER ( ALL ( Table2 ), Table2[Index] = MAX ( Table2[Index] ) - 1 )
)

Timediff = IF(NOT(ISBLANK([Previous_DateTime])),DATEDIFF([Previous_DateTime],SUM(Table2[DateTime]),MINUTE ))

Filter = IF([Timediff]>10,1)

Regards,

Cherie

[Anonymous]

Thanks @v-cherch-msft , It works