It's quite difficult to say something without seeing your data. Could you add packaged workbook (***.twbx)
The workbook has been attached to the original post.
As you may see, I just want the month filter to be able to dynamically set as previous month. And at the same time, I am able to choose other months if I need.
Thank you very much!
I'm afraid that this is not completely meet the request, but some hints hopefully.
[Selected Date Range YYYYMM] // to show YYYYMM format month
year(dateadd('month',-[Relative Month Select],today()))*100+month(dateadd('month',-[Relative Month Select],today()))
[Date Range Filter]
if year([Month Start])*100+month([Month Start])=[Selected Date Range YYYYMM] then "Show" else "hide" end
Put [Date Range Filter] to filter shelf with filtering "show" only.
relative date_SM_9.2.twbx 34.3 KB