Sequential filter

[sabinocivita]

Hi all, 

I have this problem. I have a table with a date fied, called 'CreationDate'. I want to create a view (table) that includes rows with CreationDate of last 12 months and count of them are <=24 (count must be do in tle last 12 months data.....)

How to do this in DAX?

Thanks!

[sabinocivita]

Yes, I have also a field 'CodCli' containing Customer Code. So I want to have a table with last 12 months data but where count for each codcli is ge 24 (this count must be done only on the last 12 months data not on the entire table....). I want ot avoid to build firts a temporarary table....is it possible?

[amitchandak]

@sabinocivita , nor clear with count part

tyou can have new table calculatetable(Table, filter(Table, Table[CreationDate] >= eomonth(today(),-12)+1 && Table[CreationDate] <= eomonth(today(),0) ) )