Log In
Register
Home
Power Pivot
May 6, 2020
Offline
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
See Answer
November 8, 2013
Offline
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.
Answers Post
1 Guest(s)
