Power BI DAX

Accounting DAX Measures

Copy DAX measure examples for common accounting 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.

Accounts Receivable Turnover

Accounts Receivable Turnover =
DIVIDE(
    [Net Credit Sales],
    [Average Accounts Receivable]
)

Accounts Payable Turnover

Accounts Payable Turnover =
DIVIDE(
    [Net Credit Purchases],
    [Average Accounts Payable]
)

Days Sales Outstanding

Days Sales Outstanding =
DIVIDE([Accounts Receivable], [Credit Sales]) * [Days]

Days Payable Outstanding

Days Payable Outstanding =
DIVIDE([Accounts Payable], [Cost of Goods Sold]) * [Days]

Inventory Turnover

Inventory Turnover =
DIVIDE(
    [Cost of Goods Sold],
    [Average Inventory]
)

Working Capital Ratio

Working Capital Ratio =
DIVIDE(
    [Current Assets],
    [Current Liabilities]
)

Debt Ratio

Debt Ratio =
DIVIDE(
    [Total Debt],
    [Total Assets]
)

Asset Turnover

Asset Turnover =
DIVIDE(
    [Revenue],
    [Average Total Assets]
)

Operating Cash Flow Ratio

Operating Cash Flow Ratio =
DIVIDE(
    [Operating Cash Flow],
    [Current Liabilities]
)

Expense Ratio

Expense Ratio =
DIVIDE(
    [Operating Expenses],
    [Revenue]
)

Budget Variance

Budget Variance =
[Actual Amount] - [Budgeted Amount]