Forum Discussion
Special date parameters
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.
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.