Forum Discussion

VOx15's avatar
VOx15
Icon for Helper I rankHelper I
5 years ago
Solved

Date from Previous Row into new column

Hello all,  I have been trying to figure this out for a while and would appreciate any insight.    My current data only has the Entry Date field and I am trying to create a new ExitDate field by g...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    My formula returns the correct result.  See the screenshot

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Try this calculated column formula

=calculate(min(data[entry_date]),filter(data,data[account number]=earlier(data[account number])&&data[Current queue]>earlier(data[current queue])))

Hope this helps.