Calculate Revenue Growth Rate
Result—
Formula
(Current Period Revenue - Previous Period Revenue) / Previous Period RevenueExcel formula
=IFERROR((B2-C2)/C2,0)
Power BI DAX measure
Revenue Growth Rate =
DIVIDE(
[Current Revenue] - [Previous Revenue],
[Previous Revenue]
)