Forum Discussion
Calendar table needs to filter by fact table
I am using on-prem AS so I couldn't use the proposed solution. I created a calculated column on my calendar table that is essentially a flag for whether each date is <= MAX date in my sales table. Then I used that flag as a filter for my calendar slicer.
Super UserHi Anonymous,
Try this:
1. Create a calculated table that uses the min and max dates from the fact table.
Example: SalesDates = CALENDAR ( MIN ( Sales[OrderDate] ), MAX ( Sales[OrderDate] ) )
2. Create a relationship between the calculated table and the fact table.
3. Create a date slicer using the calculated table.
You may need to enable the option below:
I am using on-prem AS so I couldn't use the proposed solution. I created a calculated column on my calendar table that is essentially a flag for whether each date is <= MAX date in my sales table. Then I used that flag as a filter for my calendar slicer.