Forum Discussion
Count time between rows
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 ...
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....
rpinxt Can you post your data as text?
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 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 __ResultThanks 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?