Power BI DAX
Finance DAX Measures
Copy DAX measure examples for common finance KPIs used in Power BI 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.
Finance Power BI dashboard books
Books that help you understand Finance Power BI dashboard and related business metrics more deeply.
Explore resources →
Finance Power BI dashboard audiobooks
Audiobook searches for learning Finance Power BI dashboard while commuting, walking, or working.
Explore resources →
Financial modeling Excel resources
Excel-focused resources for building KPI trackers and dashboard workflows.
Explore resources →
Business valuation resources
Practical resources for turning Finance Power BI dashboard into reports, dashboards, and business decisions.
Explore resources →
Finance KPI DAX examples
Gross Margin
Gross Margin =
DIVIDE(
[Revenue] - [Cost of Goods Sold],
[Revenue]
)Net Profit Margin
Net Profit Margin =
DIVIDE(
[Net Profit],
[Revenue]
)Operating Margin
Operating Margin =
DIVIDE(
[Operating Income],
[Revenue]
)EBITDA
EBITDA =
[Net Income] + [Interest] + [Taxes] + [Depreciation] + [Amortization]Revenue Growth Rate
Revenue Growth Rate =
DIVIDE(
[Current Revenue] - [Previous Revenue],
[Previous Revenue]
)Free Cash Flow
Free Cash Flow =
[Operating Cash Flow] - [Capital Expenditures]Cash Conversion Cycle
Cash Conversion Cycle =
[DIO] + [DSO] - [DPO]Return on Equity
Return on Equity =
DIVIDE(
[Net Income],
[Shareholders Equity]
)Return on Assets
Return on Assets =
DIVIDE(
[Net Income],
[Total Assets]
)Return on Invested Capital
Return on Invested Capital =
DIVIDE(
[NOPAT],
[Invested Capital]
)WACC
WACC =
VAR EquityValue = [Equity Value]
VAR DebtValue = [Debt Value]
VAR TotalCapital = EquityValue + DebtValue
RETURN
DIVIDE(EquityValue, TotalCapital) * [Cost of Equity]
+ DIVIDE(DebtValue, TotalCapital) * [Cost of Debt] * (1 - [Tax Rate])Debt-to-Equity Ratio
Debt-to-Equity Ratio =
DIVIDE(
[Total Debt],
[Total Equity]
)Current Ratio
Current Ratio =
DIVIDE(
[Current Assets],
[Current Liabilities]
)Quick Ratio
Quick Ratio =
DIVIDE(
[Cash] + [Marketable Securities] + [Accounts Receivable],
[Current Liabilities]
)Interest Coverage Ratio
Interest Coverage Ratio =
DIVIDE(
[EBIT],
[Interest Expense]
)Working Capital
Working Capital =
[Current Assets] - [Current Liabilities]