KPI calculator

Sales Growth Rate Calculator

Enter your values to calculate Sales Growth 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.

Calculate Sales Growth Rate

Result

Formula

(Current Sales - Previous Sales) / Previous Sales

Excel formula

=IFERROR((B2-C2)/C2,0)

Power BI DAX measure

Sales Growth Rate =
DIVIDE([Current Sales] - [Previous Sales], [Previous Sales])

Read the complete Sales Growth Rate formula guide →