I need advise on data modelling. I am building a dashboard that should have events that happened and events that are planned, these are two fact tables and I could concatenate them however when analyzing and slicing by date i want one date list box to show only valid dates for past events and another date list box that shows only dates valid for future events. if the fact table has both past events and future events is that possible or maybe there is a better way to deal with the two fact tables?
Thank you in advance
