Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
data protection
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • danextian's avatar
    danextian
    4 years ago

    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.

     

danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

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.