how to count the number of row based on date value

[MostafaGamal]

Hi All, 

if i have the following table like this 

how the calculate the number of "defect " that found more than 30 days ago, please help 

[amitchandak · Accepted solution]

@MostafaGamal ,

You have try a measure like

calculate(countrows(table), filter(table,Table[Date]<=today()-30))
calculate(countrows(table), filter(all(table),Table[Date]<=today()-30))

calculate(countrows(table), filter(all(table),Table[Date]<=<=selectedvalue(Date[Date])-30))

[Pragati11]

Hi @MostafaGamal ,

Few questions:

1. Do you want to count Number of Defects against a Department?
2. What do you mean by - number of "defect " that found more than 30 days ago? Is it 30 days ago from today's date?

Try posting a sample input with expected output. This will help in understanding the issue clearly.

Thanks,

Pragati

[MostafaGamal]

@Pragati11 

I mean the date the defect was found, i want to know the no. of defects that has been on the system for more than 30 days 

not the defects that found in last 30 days, i expect a table with no. of defects againts department but they must be found in the system for more than 30 days