Count time between rows

[rpinxt]

Probably not that difficult but still I am strugling.

Here is the issue:

I want to make a measure that shows me how many time each step took.

So second line would be 7:34 -/- 7:32 resulting in 2 minutes.

Etc.

[rpinxt]

Thanks @Greg_Deckler bit more difficult then I was expecting.

Tried it like this but no luck yet :

Time Spent =

VAR __Current = MAX('Table 1'[Time])

VAR __PreviousDate = MAXX(FILTER('Table 1','Table 1'[Time] < EARLIER(MAX('Table 1'[Time]),1)

VAR __Previous = MAXX(FILTER('Table 1','Table 1'[Time]=__PreviousDate),[Value])

RETURN

  __Current - __Previous

But it starts to go wrong in the EARLIER part....

[Greg_Deckler]

@rpinxt Can you post your data as text?

[rpinxt]

@Greg_Deckler  you mean like this?

Date	Name	Time	Process
01-02-24	ALHAJJX	07:32:47	Sumtotal
01-02-24	ALHAJJX	07:34:54	Apply
01-02-24	ALHAJJX	10:32:36	Pauze Uit
01-02-24	ALHAJJX	10:51:13	Pauze Uit
01-02-24	ALHAJJX	11:24:17	Apply
01-02-24	ALHAJJX	12:30:54	Pauze In
01-02-24	ALHAJJX	13:05:07	Pauze Uit
01-02-24	ALHAJJX	15:01:02	Pauze In
01-02-24	ALHAJJX	15:19:09	Pauze Uit
01-02-24	ALHAJJX	15:36:23	Apply
01-02-24	ALHAJJX	15:57:11	Stop

[Greg_Deckler]

@rpinxt Perfect! Try this (PBIX is attached below signature)

Time Spent (Minutes) = 
    VAR __Current = [Time]
    VAR __Previous = MAXX(FILTER('Table 1','Table 1'[Time] < __Current),[Time])
    VAR __Result = IF( __Previous = BLANK(), 0, ( __Current - __Previous ) * 1. * 24 * 60)
RETURN
    __Result

[rpinxt]

Thanks very much Greg.

First thought you made a measure but this is calculated column correct?

Works like a charm.

But I have a new concern now....

Out columns have a different order, I set that order in a table visual.

I tried changing the columns in the query editor but the original order remains in the table view in Power BI.

Is there another solution to change the order of the columns then change it in the source?

[Greg_Deckler]

@rpinxt See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395....
The basic pattern is:
Column = 
  VAR __Current = [Value]
  VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])

  VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
  __Current - __Previous