Answers.Body: <p>This <a href="https://github.com/fuzionnz/nz.co.fuzion.historicmembershipdata" rel="nofollow noreferrer">extension</a> may help similar questions in future</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-11-05T00:13:54.890Z
Answers.LastActivityDate: 2020-11-05T00:13:54.890Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>The CiviCRM Membership records themselves don't provide a complete or reliable history of memberships, which is why reports based on them (i.e. the Membership reports) aren't useful to you for this purpose. </p>
  
  <p>They do contain a "join" date separately from the "start" date which could be used to make a reasonable guess about membership totals in the past, but this isn't reliable (e.g. if a membership is deleted, or if this field is not used as expected.)</p>
  
  <p>The churn extension, as well as the membership dashboard, make use of the CiviCRM Activity records to calculate when a new membership is created or renewed or expires (because each of those leave behind an activity record). This is probably the best tool for what you want, though it can be misleading as well (especially if you've imported your membership records into CiviCRM from a different sytem).</p>
  
  <p>I haven't seen any off-the-shelf Civi Reports that make use of these records.</p>
  
  <p>My general advice to anyone who wants to have historical comparisons of membership data is to download the membership data at defined intervals.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-28T19:11:24.247Z
Answers.LastActivityDate: 2020-04-28T19:11:24.247Z
Answers.UserDisplayName: Alan Dixon
Body: <p>I'm using Reports, Membership Reports, Membership Summary.  In the filter section it seems to require "Member</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-04-23T19:14:15.353Z
Comments.Text: you could try the Membership Churn extension as it provides some additional data
Comments.UserDisplayName: petednz - fuzion
Tags: <database>
Title: How do I find the number of our association's members at the end of each calendar year?
ThreadText: # How do I find the number of our association's members at the end of each calendar year?
  
  (Asked by: username_0 on 2020-04-23)
  
  I'm using Reports, Membership Reports, Membership Summary. In the filter section it seems to require "Member
  
  **Tags:** database
  
  > **Comments:**
  > **username_1**: you could try the Membership Churn extension as it provides some additional data  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2020-11-05. Score: 1
  
  This [extension](https://github.com/fuzionnz/nz.co.username_1.historicmembershipdata) may help similar questions in future
  
  
  ---
  
  ### Answer by username_2 on 2020-04-28. Score: 1
  
  The CiviCRM Membership records themselves don't provide a complete or reliable history of memberships, which is why reports based on them (i.e. the Membership reports) aren't useful to you for this purpose.
  
  They do contain a "join" date separately from the "start" date which could be used to make a reasonable guess about membership totals in the past, but this isn't reliable (e.g. if a membership is deleted, or if this field is not used as expected.)
  
  The churn extension, as well as the membership dashboard, make use of the CiviCRM Activity records to calculate when a new membership is created or renewed or expires (because each of those leave behind an activity record). This is probably the best tool for what you want, though it can be misleading as well (especially if you've imported your membership records into CiviCRM from a different sytem).
  
  I haven't seen any off-the-shelf Civi Reports that make use of these records.
  
  My general advice to anyone who wants to have historical comparisons of membership data is to download the membership data at defined intervals.
  
  
  ---
  
  