Showing last 6 months data based on month as slicer

[Anonymous]

Hi ,
I have an  issue where i need to show last 6 months data based on the selection of the slicer which is basically a month slicer(Jan,Feb) .

In my model i do have one date dimension on which multiple measures has been calculated so i can't have other date dimension 

We were able to achieve it by providing a slicer of date which is basically coming from a different table which has been created apart from the date dimensiion.

Can you please guide me through what could be necessary steps to be taken to achieve this scenerio ?

Any help would be really appreciated. 

Regards
Prabin Nepak

[v-yuta-msft · Accepted solution]

@Anonymous ,

Create a measure using DAX like pattern below:

Result =
VAR Current_Month =
    MONTH ( Table[Date] )
VAR Previous_Month =
    MONTH ( Table[Date] ) - 5
RETURN
    CALCULATE (
        SUM ( Table[Value] ),
        FILTER (
            Table,
            MONTH ( Table[Date] ) >= Previous_Month
                && MONTH ( Table[Date] ) <= Current_Month
        )
    )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.