Forum Discussion

Arnaud_37's avatar
Arnaud_37
New Member
4 years ago
Solved

Calculate date between 2 rows

Hi all,   I want to calculate the duration of an action. I have a row which indicates the DateTime when the action starts. The column "Message" ends with "démarrée". I have another row which indi...
Need Help
  • BITomS's avatar
    BITomS
    4 years ago

    Arnaud_37 

     

    Okay, so if you revert to your second screenshot (your initial response to me), you could select one of the pivoted columns (start or end) and then select 'Fill' from the Transform tab within the ribbon (Up or Down will depend on if you've used start or end). Then you can just deselect the NULLs from the other column and I think this should get you there.

BITomS's avatar
BITomS
Solution Supplier
4 years ago

Hi Arnaud_37,

 

You can use the Pivot Column functionality. If you select the Message column and go to 'Transform' in the ribbon > Pivot Column, you can Set the value as DateHeure (Don't Aggregate):

 

 

Then you can go to 'Add Column' within the ribbon to add a new custom column which will be a simple End minus Start time formula to get the duration. Hope this helps.