locked
excel - powerquery - calculated column RRS feed

  • Question

  • I have the following scenario:

    A text file with data, where one column is datetime and containing the date and time when the record has been entered.

    I made a query (power query) in excel to read in the data, do some filtering etc and load the result to a table on a worksheet.

    I want to have an extra column next to that table, where I calculate the change in time between the records (ie datetime record 2 minus datetime record 1... ). The formula speaks for itself, but my question is: how to let automatically expand and shrink the height of the new column when the number of records changes and keep the calculation right?

    KR

    Wannes

    Wednesday, April 4, 2018 6:21 PM

All replies