Need Help with Running Total for Last 12 Months

[MITHUN_NAIR]

Hi All, Need help in Creating the Running Total for the Last 12 Months . 

Like 3,5,6,9,12,14,18,20,21,23

I have created below code but it is not working 

Running Total =

Var EndDate =

    Calculate(MAX(Table1[dateofjoining] ),All('Date'))

VAR StartDate =

    Date(Year(EndDate),MONTH(EndDate)-12,Day(EndDate))

Var Last12Months=Filter(

           'Date',

            'Date'[Date]>=StartDate && 'Date'[Date]<=EndDate)

Var a = MAX('Date'[Date])

Var b = CALCULATE(MIN('Date'[Date]),ALLSELECTED('Date'))

Var Result=CALCULATE(DISTINCTCOUNT(Table1[person]),FILTER(Last12Months,[Date]>=b &&[Date]<=a))

RETURN

   Result

Am not able to use the ALL function to Remove Filter from for Table Expression  i.e. Last12Months Variable from Result Variable

[Jihwan_Kim]

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Person count: = 
COUNTROWS( VALUES(Data[Person]) )

Expected result measure: =
VAR _slicerselect =
    MAX ( 'Slicer table'[Month-Year sort] )
VAR _lasttwelvemonths =
    SUMMARIZE (
        FILTER (
            ALL ( 'Calendar' ),
            'Calendar'[Date] <= EOMONTH ( _slicerselect, 0 )
                && 'Calendar'[Date] > EOMONTH ( _slicerselect, -12 )
        ),
        'Calendar'[Month-Year],
        'Calendar'[Month-Year sort]
    )
VAR _result =
    CALCULATE (
        SUMX ( VALUES ( 'Calendar'[Month-Year sort] ), [Person count:] ),
        WINDOW (
            1,
            ABS,
            0,
            REL,
            _lasttwelvemonths,
            ORDERBY ( 'Calendar'[Month-Year sort], ASC )
        )
    )
RETURN
    _result