help with first sorted value

[alinesobrinho]

Hi guys,

I need to sum the values Qty considering the period, so my dataset is like this:

Product Date Qty KEY Sum Aggr
1 01/12/2021 93 1|10|20|Text 0 0
1 01/11/2021 93 1|10|20|Text 0 0
1 01/08/2021 279 1|10|20|Text 465 279
2 01/09/2020 93 2|10|20|Text2 0 93
my sum measure is:

sum(aggr(Sum({$<[Date]={"$(='>=' & AddMonths(MonthStart(max([Date])),-11)& ' <= ' & Date(Max([Date]), 'DD/MM/YYYY'))"}>} Qty),[Key]))

my aggr measure is:

=sum(aggr(FirstSortedValue(Qty ,-aggr(max(Date),[Key])),[Key]))

This return null
=FirstSortedValue({<[Date]={"$(='>=' & AddMonths(MonthStart(max([Date])),-11)& ' <= ' & Date(Max([Date]), 'DD/MM/YYYY'))"}>}
Aggr(Sum({<[Date]={"$(='>=' & AddMonths(MonthStart(max([Date])),-11)& ' <= ' & Date(Max([Date]), 'DD/MM/YYYY'))"}>}Qty),[%SK_PriceCheck]),
Aggr(Only({<[Date]={"$(='>=' & AddMonths(MonthStart(max([Date])),-11)& ' <= ' & Date(Max([Date]), 'DD/MM/YYYY'))"}>}[Key]), [Key]))

The expected result is

Product KEY Sum
1 1|10|20|Text 465
2 2|10|20|Text2 93

Please, can someone help me?

thank you