Forum Discussion
Solved
Date it became first active
Hi,
I have data like this
| Id | Date | Status |
| 1 | 01/03/2022 | Inactive |
| 1 | 02/03/2022 | Active |
| 1 | 05/03/2022 | Active |
| 2 | 03/03/2022 | Inactive |
| 2 | 04/03/2022 | Active |
| 2 | 05/03/2022 | Active |
I want to know the date it first became Active.
My desired output
| Id | Date | Status | First_Active |
| 1 | 01/03/2022 | Inactive | 02/03/2022 |
| 1 | 02/03/2022 | Active | 02/03/2022 |
| 1 | 05/03/2022 | Active | 02/03/2022 |
| 2 | 03/03/2022 | Inactive | 04/03/2022 |
| 2 | 04/03/2022 | Active | 04/03/2022 |
| 2 | 05/03/2022 | Active | 04/03/2022 |
2 Replies
Thanks NickolajJessen that worked. Thank you so much
