Filter date range based in fact table

[samudralb]

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,

[lbendlin · Accepted solution]

It would be better to limit your Calendar table such that it covers your fact dates, but not more.

[danextian · Accepted solution]

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 ()

[lbendlin · Accepted solution]

It would be better to limit your Calendar table such that it covers your fact dates, but not more.