Forum Discussion

wiselyman3's avatar
wiselyman3
Helper II
2 years ago
Solved

Count Rows older than 7 days

Hi All,    I am trying to create a visual that shows the number of complaints (rows) that are older than 7 days. Each row has a date in the "Date" column, and this column is formatted as a date. I ...
Need Help
  • ChiragGarg2512's avatar
    ChiragGarg2512
    2 years ago

    wiselyman3  Try this measure:

    Num =
    var _v = TODAY()-7
    return
    CALCULATE(COUNT(q5[Complaint Number]), FILTER(q5, q5[Date]<= _v))
     
    P.S. q5 is the name of the table.
     
    Thank You, accept as solution if this helps.
Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

hi, wiselyman3 

try below measure 

 

COUNTROWS(FILTER(da,CONVERT(TODAY()-'da'[Date],INTEGER)>7))
 
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.