Calculate last 12 months from Selected Month from Slicer

[Anonymous]

Hi Experts

See attached Sample File

I am trying to dynamically calculate the last 12 months from the selcted month on the slicer. 

Sample Data
https://www.dropbox.com/s/va9t5wrkxxjjpls/v1.3.pbix?dl=0 

[niteshtrehan89 · Accepted solution]

Hi

Can you please try the below dax function

Sales =

VAR CurrentDate = SELECTEDVALUE(‘Date'[End of Month Date],MAX(‘Date'[End of Month Date]))

VAR PreviousDate = CurrentDate – 365

RETURN

CALCULATE(

    SUM(Table[SalesAmount]),

    FILTER(

        Table,

        Table[End of Month Date] >= PreviousDate && Table[End of Month Date] <= CurrentDate

    )

)

[niteshtrehan89 · Accepted solution]

Hi

Can you please try the below dax function

Sales =

VAR CurrentDate = SELECTEDVALUE(‘Date'[End of Month Date],MAX(‘Date'[End of Month Date]))

VAR PreviousDate = CurrentDate – 365

RETURN

CALCULATE(

    SUM(Table[SalesAmount]),

    FILTER(

        Table,

        Table[End of Month Date] >= PreviousDate && Table[End of Month Date] <= CurrentDate

    )

)

[Anonymous · Accepted solution]

Hi Nitesh. The measure is not working, can you kinldy test uing the Sample file.