Forum Discussion

sabinocivita's avatar
sabinocivita
Frequent Visitor
3 years ago

Sequential filter

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 <=2...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

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) ) )