Forum Discussion
VOx15
Helper I
Helper IDate 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...
Hi,
My formula returns the correct result. See the screenshot
VOx15Helper I
Helper IAshish_Mathur here is some sample results. The exit date column is my desired result. The only issue with your formula is that when the Entry data repeats is shows blank even though there is a next queue (like below). Keep in mind this is very simplified. My actual queue name are different.
| Account Number | Current Queue | Entry Date | Exit Date | Results w Dax |
Account 1 | Queue 1 | 10/13/2020 | 10/23/2020 | 10/23/2020 |
| Account 1 | Queue 2 | 10/23/2020 | 10/23/2020 | 10/23/2020 |
| Account 1 | Queue 3 | 11/16/2020 | 11/21/2020 | 11/21/2020 |
| Account 1 | Queue 4 | 11/21/2020 | 11/23/2020 | 11/23/2020 |
| Account 1 | Queue 5 | 11/23/2020 | 11/23/2020 | blank |
| Account 1 | Queue 6 | 11/23/2020 | blank |
Ashish_Mathur
Super User
Super UserHi,
My formula returns the correct result. See the screenshot