TopN with Date filter e.g ( i want to get top 10 skus in last six months

[Asim458]

Top25Skus =

VAR SelectedBrand = SELECTEDVALUE('Shift item codes'[Brand])

RETURN

CALCULATE(

    SUMX(

        TOPN(25, FILTER('Shift item codes', 'Shift item codes'[Brand] = SelectedBrand), [Total Purchases], DESC),

        [Total Purchases]

    )

)

[Daoud_H · Accepted solution]

Hi @Asim458,

I suppose you want something like that : 

Top25Skus =
VAR SelectedBrand = SELECTEDVALUE('Shift item codes'[Brand])
VAR SixMonthsAgo = EOMONTH(TODAY(), -6) + 1
RETURN
CALCULATE(
    SUMX(
        TOPN(
            25, 
            FILTER(
                'Shift item codes', 
                'Shift item codes'[Brand] = SelectedBrand && 'Shift item codes'[Date] >= SixMonthsAgo
            ), 
            [Total Purchases], 
            DESC
        ),
        [Total Purchases]
    )
)