Forum Discussion

Karthik12's avatar
Karthik12
Post Patron
3 years ago
Solved

Time difference between current output and previous output

Hello Folks, My production server data has  time values in same coloumn (please refer attached picture). Request your help to calculate the time difference between two outputs in my production data...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, Karthik12 ;

    You could try it.

    1.create a column

     

    diff = 
var _last=
CALCULATE(MAX('Table'[Time]),FILTER('Table',[Time]<EARLIER('Table'[Time])&&[Date]=EARLIER('Table'[Date])))
return DATEDIFF(_last,[Time],SECOND)

     

    2.set top 3:

    If the above one can't help you get the desired result, please provide a simple and your expected result with backend logic and special examples.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, Karthik12 ;

You could try it.

1.create a column

 

diff = 
var _last=
CALCULATE(MAX('Table'[Time]),FILTER('Table',[Time]<EARLIER('Table'[Time])&&[Date]=EARLIER('Table'[Date])))
return DATEDIFF(_last,[Time],SECOND)

 

2.set top 3:

If the above one can't help you get the desired result, please provide a simple and your expected result with backend logic and special examples.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Karthik12's avatar
Karthik12
Post Patron
3 years ago

Hello v-yalanwu-msft Thank you so much for the support. 

I have tried to attach my pbix file but couldn't find option.

So, attached as image.

I would like to get support for a time line graph for time intervals between latest time and previous time.

like below. Obvisiouly, first part time interval should be calculated as shift start time as indicated below.

 

 

 Hope this data give some clarity to you. If not, any alternate way to send pbix file to you?

Thanks in advance for your kind support !