1 of 1 people found this helpful
Find my approach as reference below and stored in attached workbook version 10.1
I defined a Union because you are not able to blend both datasources because there are not or very few entries (dates) identical in both datasources. If there is a requirement to blend then you will need the "scaffolding-techniek" to create a "backbone" of all Date-entries rom 2015-2017 on which all Date-entries of both datasources will match. I hope my explanation is clear;) An Union is the "way to go".
a, 2016 vs 2017
HAPPY NEW YEAR!:)
Thanks I see what you are saying about the union, but the 2016 data is showing all the data.
I would want it only to show the sales that were booked prior to Jan 2016 to compare to 2017.
Would you put booking date on a filter and use a formula to filter?
This is not right but it would be something like this
IF [Stay date]<12/31/2016
Then [Booking Date]<12/31/2015
ELSEIF [Stay date]>12/31/2016
then [Booking Date]>12/31/2016
Thanks for the insight
I took a look at the original data sets and also came to the conclusion that they looked more like 2 separate pieces of a single file - but I wasn't sure how to complete the viz from there.
That's not necessary just select on Booking dates <1-1-2015 it wil give you all bookings before this days with "stay-date Q1-2016.
For Q1-2017 I selected all Booking dates <1-1-2016 and "Stay-date" >1-1-2017.