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
Hi Alberto,
The SelectRows condition: each ([Numero settimana] = ParaWeek) should be:
each if ParaWeek=null then true else ([Numero settimana] = ParaWeek)
each true will return al rows if paraWeek is null.
Same for the second filter you have.
I wish I could guess these tricks by myself! But maybe I am still not so inside the M language to guess it and shoot it true.
Thanks Catalin!
