Hide it instead of filtering.
create a parameter:
Boolean calc for hiding
[Month of Date] = [Select a Month]
Put the Hide calc on the row shelf as the first pill. Right click on false and select hide. Then right click on the pill and uncheck show header.
You do need to adjust your table calc:
berg.twbx 163.1 KB
I didn't touch that calc as it was returning nulls on the file you attached originally.
1 of 1 people found this helpful
There are values for the calculation, look at the original file and scroll down to 2016-01-01 --
Because it is a lookup formula, it won't work when filtering on month.
I think your solution works the same as a filter.
Not showing ex. 364 dates, it cannot look up with the offset -364 days.
See what I mean?
Thanks for keeping trying!!!