Financial functions - Profitbase/PowerBI-visuals-FinancialReportingMatrix GitHub Wiki

Financial functions

CAGR(beginningValue, endingValue, years)
Calculates compound annual growth rate.

YoY(pastValue, presentValue)
Calculates year-over-year growth.

AMORLINC(cost : number, date_purchased : Date, first_period : Date, salvage : number, period : number, rate : number [,basis : number])

AMORLINCMTH(cost : number, date_purchased : Date, first_period : Date, salvage : number, period : Date, rate : number [,basis : number])