KPI calculator

Repeat Purchase Rate Calculator

Enter your values to calculate Repeat Purchase Rate. Use the formula and examples below for Excel, Google Sheets, Power BI, and dashboards.

Affiliate resources

Ideas for You

Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.

Repeat Purchase Rate books Books that help you understand Repeat Purchase Rate and related business metrics more deeply. Explore resources → Repeat Purchase Rate audiobooks Audiobook searches for learning Repeat Purchase Rate while commuting, walking, or working. Explore resources → Ecommerce analytics resources Excel-focused resources for building KPI trackers and dashboard workflows. Explore resources → Marketplace business resources Practical resources for turning Repeat Purchase Rate into reports, dashboards, and business decisions. Explore resources →

Calculate Repeat Purchase Rate

Repeat Customers Total Customers

Result—

Formula

Customers with More Than One Purchase / Total Customers

Excel formula

=IFERROR(B2/C2,0)

Power BI DAX measure

Repeat Purchase Rate =
DIVIDE(
    [Repeat Customers],
    [Total Customers]
)

Read the complete Repeat Purchase Rate formula guide →