Forum Discussion

1 Reply

  • grantsamborn's avatar
    grantsamborn
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi bilibi2928 

    Would the following 2 measures help?

     

    Last Year = 
    CALCULATE(
        [Sales],
        DATESBETWEEN(
            'Date'[Date],
            DATEADD( LASTDATE( 'Date'[Date] ), -1, YEAR ),
            LASTDATE( 'Date'[Date] )
        )
    )


Rankx = 
    RANKX(
        ALL( 'Product' ),
        [Last Year],
        ,
        DESC
    )

     

    [Rankx] can be used to filter a visual.

    Let me know if this helps.