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 <=24 (count must be do in tle last 12 months data.....)

How to do this in DAX?

 

Thanks!

 

Need Help

2 Replies

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

  • sabinocivita's avatar
    sabinocivita
    Frequent Visitor
    3 years ago

    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?