My fact table consists of transactional records that all have start & end dates.
In that respect are Different to 'standard' transactions that just occur on a single date.
With that, I am really struggling on the best approach (or even just 'how') to mange these in QV, with regard to linking to calendar.
A normal transaction is easy, it has 1 date field linked to calendar, and filtering on any date just gives 1 result.
In my new case, filtering on a date, requires looking at each transactional record's start and end dates, and if the filtered date is in-between the two.
That would mean in effect linking the calendar to TWO fields on my fact table with 'greater than' and 'less than' expressions - is that even possible in QV ?
Any pointers on where to even start looking for a solution, would be gratefully received !
