Forum Discussion
Solved
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 the...
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 ()
danextian
Super User
Super UserHi 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 ()