Forum Discussion
working out count based on date
Hi All, I'm looking for a solution for this problem. i have a table such as below: What i want to do is count the number of items which have moved to done in the last 30 days, ba...
Used this solution in the end, as it gave me what i needed.
Done in last 30 Days = IF(AND(AND([OLD_VALUE_FORMATTED]<> "Done", [NEW_VALUE_FORMATTED]="Done"), [CREATED].[Date]>=Today()-30),1,0)
That shouldn't be much of an issue imho.
Something like this should do it:
CALCULATE(COUNTROWS(YourTable), [Old Value] <> "Done", [New Value] = "Done", DATESBETWEEN(MyDateTableDateColumn, Today() - 30, Today()))