Calculate Sales Velocity
Result—
Formula
(Opportunities × Average Deal Size × Win Rate) / Sales Cycle LengthExcel formula
=IFERROR((B2*C2*D2)/E2,0)
Power BI DAX measure
Sales Velocity =
DIVIDE(
[Opportunities] * [Average Deal Size] * [Win Rate],
[Sales Cycle Length]
)