Parameter Table and wildcards|Power Query|Excel Forum|My Online Training Hub

Hi all,

I am trying to build a 2020 calendar with a small parameter table. My parameter table has just two values: Month and Week Number.

Say that I want to use the parameter table both having two parameters set or just one leaving the other one blank, is there any way I can replicate the wildcard * concept so that if I leave one parameter blank the output table comes out unfiltered by that parameter? To be more specific i.e. I would like to choose the month but not a specific week of that month or instead choose month and week.

Thanks,

Alberto