Forum Discussion
Dynamic filtering
Hi, I was wondering if I can apply a dynamic filter in Desktop. A table (directly to SQL Server OLTP DB) has column [Year] (= transactional year) and I added custom column [CurrYear] to that rec...
The best eway to accomplish that is in query editor since you will end up with a smaller data model.. greggyb has a great solution in query editor that is exact what you need ( I thing for rlolling months but you can adjust it for years ) but I cannot dig up his post..
If he cannot reply I wrote a post how to create dynamic filtering in Query editor but is based on dates in other tables..i.e if you need the date dimention to contain dates that are only is transactional table..