I would like to show performance of the current month (or year) excluding today's date, how can this be achieved?
If we're talking about a Looker explore, the way I'd do this is by creating two filters on the date field. One to specify the month to date period ("is in the last 1 months"), and one to exclude today ("is before (relative) 0 days").
I'd probably use a similar approach on a dashboard - that is, create two filters - but I wonder if anyone has thought of a better way?
You can check this post if you want to filter data MTD or YTD format based on user selection.
How to implement DatesYTD and DatesMTD using Look... - Google Cloud Community