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:
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 |
Solved! Go to Solution.