Forum Discussion
Special date parameters
Hi, don't know if it's possible to do with parameters, but need 2 parameters 1 for the current year and the other for the previous month of the actual month. So when the report opens it automatically filters the visuals in the report that depends on the 2 slicers now, year and month. Any other ideas on how to do it are welcome. Thanks.
I recommend you do this as a calculated column in your calendar table. I normally have a regular year column and a regular month column. Then create a second set of columns and create a test that swaps the current year and current month to the word "current" or similar. Then add these new columns as slicers on your report. As the report refreshes, the new 2x columns will change the reference as needed.
2 Replies
I recommend you do this as a calculated column in your calendar table. I normally have a regular year column and a regular month column. Then create a second set of columns and create a test that swaps the current year and current month to the word "current" or similar. Then add these new columns as slicers on your report. As the report refreshes, the new 2x columns will change the reference as needed.
Wow! Thanks Matt, what great idea.
