Forum Discussion
Cross Filtering calendar table
I have a calendar table that goes from 1901 up to 2020 and another tables have data from 2018 to 2020. When I add a slicer, it shows dates from the entire period in the calendar table. How do I displa...
Thanks for your comment. I found a much simpler solution. When you add a column to the values bucket, only the records with data in that column appears in the filter list.
Thanks,
Anton
You could try creating a date table that uses your fact table to determine the min and max dates that it should show.
Something like Date=calendar(min(salesdate), max(salesdate))
This should create a date table with contiguous dates between your first and last sale.
Thanks for the reply but I need to use the Calendar table from the data warehouse. Besides my sales table has data till the end of the fiscal year and I want to show dates only till the current month.