Forum Discussion
ss8551
Helper II
Helper II2 date fields need to populate 3rd column if training date is greater than start date
I have a file that has employee ID's Training Dates and Start Dates. I need to create a new column that will populate the training date if the training date is greater than or equal to the Start Date, otherwise leave the rows blank.
Example below, Please note that the Training date is a measure the others are columns. I am attempting to create the Trained Column as a Calculated Column.
| Empl_id | Training Date | Start Date | Trained |
| AB123 | 4/5/2022 | ||
| AB123 | 4/6/2022 | ||
| AB123 | 4/7/2022 | ||
| AB123 | 4/8/2022 | ||
| AB123 | 4/9/2022 | ||
| AB123 | 4/10/2022 | ||
| AB123 | 4/11/2022 | ||
| AB123 | 4/12/2022 | ||
| AB123 | 4/13/2022 | ||
| AB123 | 4/14/2022 | ||
| AB123 | 4/15/2022 | ||
| AB123 | 4/16/2022 | 4/16/2022 | 4/16/2022 |
| AB123 | 4/17/2022 | 4/16/2022 | |
| AB123 | 4/18/2022 | 4/16/2022 | |
| AB123 | 4/19/2022 | 4/16/2022 | |
| AB123 | 4/20/2022 | 4/16/2022 | |
| AB123 | 4/21/2022 | 4/16/2022 | |
| AB123 | 4/22/2022 | 4/16/2022 | |
| BC456 | 4/19/2022 | ||
| BC456 | 4/20/2022 | ||
| BC456 | 4/21/2022 | ||
| BC456 | 4/22/2022 | ||
| BC456 | 4/23/2022 | 4/23/2022 | 4/23/2022 |
| BC456 | 4/24/2022 | 4/23/2022 | |
| BC456 | 4/25/2022 | 4/23/2022 | |
| BC456 | 4/26/2022 | 4/23/2022 | |
| Column | Measure | Column | Column |
Is this what you are looking for?
1 Reply
- Ahmedx
Super User
Is this what you are looking for?