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.
wiselyman3's avatar
wiselyman3
Helper II
2 years ago

Apologies, this would be 2 complaints older than 7 days in this example. Long day!