Forum Discussion
visual level filter on last 3 completed months
Hi Team, I have an requirement to filter on visual level complete 3 months. I have date column in my report need to filter out only last 3 onths not rolling months. For example we now we are june, i want get filter on last 3 completed months(Mar, April, may) in visual level. How can we do that.
Hi Anonymous
Try this as a calculated column in your Dates table. Change the table and column names accordingly.
Last 3M = VAR Start3MonthsAgo = EOMONTH ( TODAY (), -4 ) + 1 VAR EndofLastMonth = EOMONTH ( TODAY (), -1 ) RETURN Dates[Date] >= Start3MonthsAgo && Dates[Date] <= EndofLastMonth.This will return True for those dates within the range. False for otherwise.
2 Replies
- danextian
Super User
Hi Anonymous
Try this as a calculated column in your Dates table. Change the table and column names accordingly.
Last 3M = VAR Start3MonthsAgo = EOMONTH ( TODAY (), -4 ) + 1 VAR EndofLastMonth = EOMONTH ( TODAY (), -1 ) RETURN Dates[Date] >= Start3MonthsAgo && Dates[Date] <= EndofLastMonth.This will return True for those dates within the range. False for otherwise.