see the attached approach
create your parameters
then this filter
place the filter on the filter shelf and set to True
you can load any of the measures and it will return the variance between the years selected
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
year filters.twbx 2.4 MB
Thanks for your response! Just a quick question since I am a bit confused. When I create the parameter, should it be in a list format with multiple years there (for example, 2016-2020). And a follow up question, this would allow me to be able to select any two years for variance from a list of years bigger than just 2 right? Thank you!
Filters are single valued and are static - that is they are set by the user, apply to the entire workbook and remain constant until changed by the user
if you want to create strings that say 2014-2016 and a separate string that says 2015-2016 and so on (they are not 2 numbers or dates)
parameters in themselves don't do anything - they need to be backed you a calculation or a filter that actual does the work
so you would need to read and breakdown the strings into years that you can use in if then statements like the ones I gave you