Semantic Models date filtering that doesn’t leak future data
Budget and prior-year lines running past today make a report look broken. Here is the Date Filter table I build in SQL, plus the cross-filter setting it needs, so a single slicer switches future data on and off.