Hello Community,
I am a beginner here, and currently working a something that I am having hard time with, I hope I can get some help here, Appreciate it!
here is the data I am working with:
1. the report is pulled every quarter end, the ReportQuarterDate = Quarter End date we pull the data
2. the logic is:
- if there is an announced date for the company, return the quarter end that the announced date occurred in
- if there is no announced date for the company, leverage the closed date and return the quarter end that the closed date occurred in
- if the company has both announced and closed date, only take the announced date.
Thanks to anyone who are helping!
| Company Name | EvenDate | Event Status | Store_AnnouncedDate | Store_ClosedDate | ReportQuarterDate |
| A | 2021-03-15 | ANNOUNCED | 2021-03-15 | | 2019-09-30 |
| A | 2021-04-28 | CLOSED | | 2021-04-28 | 2019-09-30 |
| A | 2021-03-15 | ANNOUNCED | 2021-03-15 | | 2019-12-31 |
| A | 2021-04-28 | CLOSED | | 2021-04-28 | 2019-12-31 |
| A | 2021-03-15 | ANNOUNCED | 2021-03-15 | | 2020-03-31 |
| A | 2021-04-28 | CLOSED | | 2021-04-28 | 2020-03-31 |
| A | 2021-03-15 | ANNOUNCED | 2021-03-15 | | 2020-06-30 |
| A | 2021-04-28 | CLOSED | | 2021-04-28 | 2020-06-30 |
| A | 2021-03-15 | ANNOUNCED | 2021-03-15 | | 2020-09-30 |
| A | 2021-04-28 | CLOSED | | 2021-04-28 | 2020-09-30 |
| A | 2021-03-15 | ANNOUNCED | 2021-03-15 | | 2020-12-31 |
| A | 2021-04-28 | CLOSED | | 2021-04-28 | 2020-12-31 |
| A | 2021-03-15 | ANNOUNCED | 2021-03-15 | | 2021-03-31 |
| A | 2021-04-28 | CLOSED | | 2021-04-28 | 2021-03-31 |
| B | 2021-12-06 | ANNOUNCED | 2021-12-06 | | 2020-03-31 |
| B | 2021-12-06 | ANNOUNCED | 2021-12-06 | | 2021-06-30 |
| B | 2021-12-06 | ANNOUNCED | 2021-12-06 | | 2021-09-30 |
| B | 2021-12-06 | ANNOUNCED | 2021-12-06 | | 2021-12-31 |
| B | 2021-12-06 | ANNOUNCED | 2021-12-06 | | 2022-03-31 |
| B | 2021-12-06 | ANNOUNCED | 2021-12-06 | | 2022-06-30 |
| C | 2020-03-06 | CLOSED | | 2020-03-06 | 2020-03-31 |
| C | 2020-03-06 | CLOSED | | 2020-03-06 | 2020-09-30 |
| C | 2020-03-06 | CLOSED | | 2020-03-06 | 2019-12-31 |
| C | 2020-03-06 | CLOSED | | 2020-03-06 | 2021-12-31 |
| Company Name | EvenDate | Event Status | Store_AnnouncedDate | Store_ClosedDate | ReportQuarterDate | EventQuarterDate |
| A | 2021-03-15 | ANNOUNCED | 2021-03-15 | | 2019-03-31 | 2021-03-31 |
| B | 2021-12-06 | ANNOUNCED | 2021-12-06 | | 2021-12-31 | 2021-12-31 |
| C | 2020-03-06 | CLOSED | | 2020-03-06 | 2020-03-31 | 2020-03-31 |
