get count of last month from sharepoint column

[NewLearner1]

Hi,

I have column saying Status and another column is End Date, want to show count of the records based on the below conditions:

Conditions :

Status= Completed

End Date = last month

means, i want to display the count ,for last month whose status is "completed" (Displaying the count on lable).

I have tried the below code:

CountRows(Filter(SPList,'Status'.Value="Completed" And Month('End Date')=Month((DateAdd(Now(),-1,Months)))))

getting output 0 but i have 22 records in my SPList.

Please help.

[WarrenBelz · Accepted solution]

Hi @NewLearner1 ,

Try this

CountRows(
   Filter(
      SPList,
      Status.Value="Completed" &&
      DateDiff(
         'End Date',
         Now(),
         Months
      )=1
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[WarrenBelz]

Hi @NewLearner1 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.