Hello all,
I am trying to figure out how to take the latest date from one column and impute it as a separate value in a separate column.
For example:
Before:
| Value | Date |
| 1 | 02-16-2023 |
| 2 | 01-06-2026 |
| 3 | 04-25-2023 |
| 4 | 03-12-2023 |
After:
| Value | Date | Latest Date |
| 1 | 02-16-2023 | 04-25-2023 |
| 2 | 01-06-2026 | 04-25-2023 |
| 3 | 04-25-2023 | 04-25-2023 |
| 4 | 03-12-2023 | 04-25-2023 |
Any help would be greatly appreciated. Thanks!
