This is an issue that comes up once in a while. There are always multiple alternative solutions to the same issue in Tableau. Here is my favorite one. Simple and easy. No need to use Index() function. It applies to current month/year or last N months/years.

[Update: After publishing this blog, I found that, since Tableau 10.3, a new feature has been added to ease the pain. It basically solved the problem. For those who are still using 10.2 or who like to understand the Top option of the filter, this blog still can help.

2
Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.