Bookmark with slicers

Hi ysapiyev,

I have a dahsboard, that need to have last month always showing however I compare with AOP and Forecast that goes all the way until december, and getting the current month value for actuals based on slicer was always giving me 0 because there were no actuals on the maximum date (december)

I use a change on my actuals measures to look something like this:

Current Year = 
VAR Selected_Min_Date =
    MIN ( Dim_date[Date] )

// Select Mininum date of calendar to get year

VAR Select_Max_Month =
    MAX ( Dim_Date[Month] )

// Select Maximum date to check if it's until december

RETURN
    IF([Actuals] = 0; BLANK();IF (
        DISTINCTCOUNT ( Dim_Date[Month] ) = 12;
        CALCULATE (
            [Actuals];
            Dim_Date[Date]
                = DATE ( YEAR ( Selected_Min_Date ); IF(MONTH ( TODAY () ) = 1 ; 12 ; MONTH(TODAY())  - 1) ; 1 )

// choose the month before current month

        );
        CALCULATE ( [Actuals] ; Dim_Date[Month] = Select_Max_Month)
    )) //otherwise give current monthn

Maybe you can use something similar to adjust your values to get the last 3 months.

Regards,

MFelix