I've attached an image of parameters I am using in an excel spreadsheet. I cannot attach the actual spreadsheet for privacy reasons unfortunately. I am using these parameters to filter down a large query from a SQL database. Is there a way to enter or select multiple values for the parameter rather than just having to input them each one by one? For example, I'd like to be able to choose both 2018 and 2019 for the Year rather than having to type them in and look at them separately.
I appreciate any insight on this or even if you feel there may be a good way to at least begin to approach this, I'd be happy to hear your thoughts. (i.e. Using VBA or Power Query Advanced Editor to code a solution). Thanks in advance!
Bookmarks