roll back 12 months

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

Has both time intelligence formulas and just standard filtering. 

Hi Anonymous ,

Would you please try to use the  DATESINPERIOD function to create measure? Here is the sample measure for you reference:

Measure =

VAR a =

    CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )

RETURN

    CALCULATE (

        SUM ( 'Table'[sales] ),

        FILTER (

            ALL ( 'Table' ),

            DATESINPERIOD (

                'Table'[Date],

                DATE ( YEAR ( a ), MONTH ( a ), 1 ),

                -11,

                MONTH

            )

        )

    )

Best Regards,

Dedmon Dai