Forum Discussion
Filter date range based in fact table
Hi,
I have a Date Dimensions which has data from 1990 to 2099 and I'm using year as my report filter, and I need to show some values in a line chart based on the fact table but it showing all these date ranges in line chart. How can I filter only exisiting dates based on fact table (Even I need to apply this to the year filter as well).
Thanks,
It would be better to limit your Calendar table such that it covers your fact dates, but not more.
Hi samudralb ,
Isn't a calendar table of up to 2099 an overkill? I have a calendar table of up to 8 weeks from today but that is because I use the future dates for forecasting. If, for some reason, you really need all those, I would a future date indicator column and use that to filter the dates. Example:
IsFuture = Dates[Date] >= TODAY ()
2 Replies
It would be better to limit your Calendar table such that it covers your fact dates, but not more.
Hi samudralb ,
Isn't a calendar table of up to 2099 an overkill? I have a calendar table of up to 8 weeks from today but that is because I use the future dates for forecasting. If, for some reason, you really need all those, I would a future date indicator column and use that to filter the dates. Example:
IsFuture = Dates[Date] >= TODAY ()