calculate value except last 3 months

[Varan_15]

Hi All,

I want to calculate value except last 3 months date. 

example:  as per below screenshot i need to exclude last 3 months date.(means latest 3 months should be excluded)

output: 

Thanks,

Varan

[HassanAshas · Accepted solution]

Try this,

Count Except Last 3 Months = 
    SUMX(
        FILTER(
            Sample_Data_Table, 
            Sample_Data_Table[Date] <= DATEADD(Sample_Data_Table[Date], 3, MONTH)
        ), 
        Sample_Data_Table[Amount]
    )

This will give you following result