I have one quick question:I would have to add one date for startdate and one date for end date.This would be possible if I have 2 date fields but I have only one date field in my table.When I rename that only field with start date and end date I am getting he same date range as its only one date field.I have seen teh master calendar example posted on this forum but taht might not work as this table is joined with other tables using dat_key instead of date filed.Pls find the enclosed qvw for reference.
Thanks Miguel for your quick response.As I mentioned above I came thru this kind of approach from forums.Now my problem how to link this kind of approach with my datamodel.I have enclosed the qv for refrence.Please review.
If you choose the data island, which is correct as well, first you'd need to create a end calendar date with at least the same dates you have in your master calendar, since the starting date must never be previous to the end date, I may be missing something though.
You will always need a conditional or set analysis to force the expression to return values between two dates, in your case, startdate and enddate. It's ok if you prefer to select the date from one table instead of a variable, but anyway your main fact table date has to be between two dates. So your expression may look like