Rolling date not capturing the latest month of my dataset

[eric_005]

I have this measure created but it is not capturing my latest month of my dataset. 

If I tick April for example, it shows only Mar 23 - Mar 24. But if I tick month of May, the charts are empty.

Here is my code.  Please help.

**Total Visits | Last 13 Months =

VAR MaxDate = MAX(CalendarTable[Date])

VAR MaxDate_13MonthsAgo = EDATE(MaxDate, -13)

VAR Result =

    IF(

        HASONEVALUE(RollingDate[MonthYear]) &&

            MAX(RollingDate[Date]) <= MaxDate &&

            MIN(RollingDate[Date]) >= MaxDate_13MonthsAgo,

            CALCULATE(

                    [Total Sum Value],

                FILTER(

                    ALL(CalendarTable[Month],CalendarTable[Year],CalendarTable[MonthYear]), CalendarTable[Month] = VALUES(RollingDate[Month] ) && CalendarTable[Year] = VALUES(RollingDate[Year]) && CalendarTable[MonthYear] = VALUES(RollingDate[MonthYear])

                )

            ),

            BLANK()

    )

RETURN

    Result

[Ashish_Mathur · Accepted solution]

Hi,

I am not sure about what you want but see if my solution in the attached file helps.

[eric_005]

Hi Ashish, your solution is working! Just what I needed! Appreciate your help! 🙂