Calculation diff in mintues between 2 samples in the same row

[Bundgaard86]

Hi

how to calculate the time in mintues from a tabel and a single column, that have 3 "users/produktion" lines.

each line in the table is a measurement, and i would like to count the mintues between each measurement / line no.

my goal is to show how many stops pr. line no, has there been which have lasted over 30 mintues.

also the data is coming from a SQL enviroment, this is just an example 🙂 i can provide the excel file if this makes it easier to try out 🙂

Location	Line No	Date	Timestamp
DE	1	06-02-2020	0:00:04
DE	2	05-02-2020	0:00:07
DE	2	05-02-2020	0:00:19
DE	3	06-02-2020	0:00:43
DE	1	06-02-2020	0:00:48

[v-yingjl]

Hi @Bundgaard86 ,

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Yingjie Li

[amitchandak]

Can you provide more data and a sample output? Like the same location and date has the same line no, how to take diff.