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 ...
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?