If have an interesting scenario - My company puts on 2 Shows a year in the US - One in the Winter and one in Summer. Our Exhibit team is always working on booking exhibitors for multipleshows at the same time with overlapping dates…
Our winter show is in January 2020 - sales opened up on November 2018
Our winter show that was in January 2019 - sales open up in November 2017
Our summer show is in June 2019 - sales opened up on April 2018
Our summer show that was in June 2018 - sales open up in April 2017
Granted I know that there is only so much information I can give. I would like to put all of the “orders” in one table join it to a date table. Is there an easy way to do “to-date” calculations with multiple overlapping scenarios. See highlighted rows to show where the overlaps occur.
My goal is create some metrics for “pacing” to compare Winter TY/Winter LY and Summer TY/Summery LY - If that makes sense.
Any guidance /assistance will be greatly appreciated.