# Power BI finance app KPIs and measures
> APPLIES TO: Generally available in Business Central 2024 release wave 2.
This page provides a list of all Key Performance Indicators (KPIs) included in the semantic model for the Power BI Finance report.
Explore the list of KPIs below to learn more about how they can help you achieve your business goals.
Each KPI and measure is described, including how it is calculated and what data was used in the calculations.
> TIP
> You can easily track the KPIs that the Power BI reports display against your business objectives. See Track your business KPIs with Power BI metrics<track-kpis-with-power-bi-metrics>.
## Activity KPIs
 #-change-in-operating-profit---ebit
 #-change-in-revenue
 #asset-turnover-ratio
 #average-collection-period-days
 #cash-conversion-cycle---ccc
 #days-payable-outstanding---dpo
 #days-sales-of-inventory---dsi
 #days-sales-outstanding---dso
 #degree-of-operating-leverage---dol
 #inventory-turnover
 #no-of-days
### % change in operating profit - EBIT
Formula
( #operating-profit---ebit-balance-at-date - #operating-profit---ebit-beginning-balance ) / #operating-profit---ebit-beginning-balance
Data Sources
 G/L Entry
 G/L Account Category
### % change in revenue
Formula
( #revenue-balance-at-date - #revenue-beginning-balance ) / #revenue-beginning-balance
Data Sources
 G/L Entry
 G/L Account Category
### Asset turnover ratio
Formula
#revenue / #assets
Data Sources
 G/L Entry
 G/L Account Category
### Average collection period (days)
Formula
( #no-of-days * #accounts-receivable-net-change ) / #revenue
Data Sources
 Date
 G/L Entry
 G/L Account Category
### Cash conversion cycle - CCC
Formula
#days-sales-of-inventory---dsi + #days-sales-outstanding---dso - #days-payable-outstanding---dpo
Data Sources
 G/L Entry
 G/L Account Category
### Days payable outstanding - DPO
Formula
( #accounts-payable / #cost-of-goods-sold ) * #no-of-days
Data Sources
 Date
 G/L Entry
 G/L Account Category
### Days sales of inventory - DSI
Formula
( #inventory / #cost-of-goods-sold ) * #no-of-days
Data Sources
 Date
 G/L Entry
 G/L Account Category
### Days sales outstanding - DSO
Formula
( #accounts-receivable / #revenue ) * #no-of-days
Data Sources
 Date
 G/L Entry
 G/L Account Category
### Degree of operating leverage - DOL
Formula
#-change-in-operating-profit---ebit / #-change-in-revenue
Data Sources
 G/L Entry
 G/L Account Category
### Inventory turnover
Formula
#cost-of-goods-sold / #inventory-average
Data Sources
 G/L Entry
 G/L Account Category
### No. of days
Formula
The No. of Days measure calculates the total number of days within a selected period by counting the rows between the earliest (MIN) and latest (MAX) dates in the Date table. This measure provides a count of days for the specified date range in the context.
Date Sources
 Date
## Balance sheet measures
 #accounts-payable
 #accounts-payable-neg
 #accounts-receivable
 #accounts-receivable-average
 #accounts-receivable-beginning-balance
 #accounts-receivable-net-change
 #assets
 #capital-employed
 #current-assets
 #current-liabilities
 #equity
 #fixed-assets
 #inventory
 #inventory-average
 #inventory-beginning-balance
 #liabilities
 #liabilities--equity
 #liabilities-neg
 #liquid-assets
 #longterm-liabilities
 #payroll-liabilities
 #purchase-prepayments
 #shareholders-equity
 #working-capital
### Accounts payable
Formula
The Accounts Payable measure calculates the #balance-at-date for general ledger accounts categorized as Accounts Payable on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Accounts Payable (Level 3 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page. It then multiplies the result by -1 to display the balance as a positive value.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Accounts payable (neg)
Formula
The Accounts Payable measure calculates the #balance-at-date for general ledger accounts categorized as Accounts Payable on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Accounts Payable (Level 3 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Accounts receivable
Formula
The Accounts Receivable measure calculates the #balance-at-date for general ledger accounts categorized as Accounts Receivable on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Accounts Receivable (Level 3 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Accounts receivable (average)
Formula
( #accounts-receivable-beginning-balance + #accounts-receivable ) / 2
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Accounts receivable (beginning balance)
Formula
The Accounts Receivable (Beginning Balance) measure calculates the #balance-at-date for #accounts-receivable before the earliest date in the selected period. It removes filters on the date column and includes only dates earlier than the first selected date.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Accounts receivable (net change)
Formula
The Accounts Receivable (Net Change) measure calculates the #net-change for general ledger accounts categorized as Accounts Receivable on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Accounts Receivable (Level 3 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Assets
Formula
The Assets measure calculates the #balance-at-date for general ledger accounts categorized as Assets on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Assets (Level 1 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Current assets
Formula
The Current Assets measure calculates the #balance-at-date for general ledger accounts categorized as Current Assets on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Current Assets (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Fixed assets
Formula
The Fixed Assets measure calculates the #balance-at-date for general ledger accounts categorized as Fixed Assets on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Fixed Assets (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Inventory
Formula
The Inventory measure calculates the #balance-at-date for general ledger accounts categorized as Inventory on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Inventory (Level 3 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Inventory (average)
Formula
( #inventory-beginning-balance + #inventory ) / 2
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Inventory (beginning balance)
Formula
The Inventory (Beginning Balance) measure calculates the #balance-at-date for #inventory before the earliest date in the selected period. It removes filters on the date column and includes only dates earlier than the first selected date.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Liquid assets
Formula
The Liquid Assets measure calculates the #balance-at-date for general ledger accounts categorized as Cash on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Liquid Assets (Level 3 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Capital employed
Formula
#assets - #current-liabilities
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Equity
Formula
The Equity measure calculates the #balance-at-date for general ledger accounts categorized as Equity on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Equity (Level 1 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
It multiplies the balance by -1 to reverse the sign of credit balances.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Current liabilities
Formula
The Current Liabilities measure calculates the #balance-at-date for general ledger accounts categorized as Current Liabilities on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Current Liabilities (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page. It then multiplies the result by -1 to display the balance as a positive value.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Liabilities
Formula
The Liabilities measure calculates the #balance-at-date for general ledger accounts categorized as Liabilities on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Liabilities (Level 1 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page. It then multiplies the result by -1 to display the balance as a positive value.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Liabilities (neg)
Formula
The Liabilities measure calculates the #balance-at-date for general ledger accounts categorized as Liabilities on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Liabilities (Level 1 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Liabilities & equity
Formula
#liabilities + #equity
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Longterm liabilities
Formula
The Longterm Liabilities measure calculates the #balance-at-date for general ledger accounts categorized as Longterm Liabilities on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Longterm Liabilities (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page. It then multiplies the result by -1 to display the balance as a positive value.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Payroll liabilities
Formula
The Payroll Liabilities measure calculates the #balance-at-date for general ledger accounts categorized as Payroll Liabilities on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Payroll Liabilities (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page. It then multiplies the result by -1 to display the balance as a positive value.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Purchase prepayments
Formula
The Purchase Prepayments measure calculates the #balance-at-date for general ledger accounts categorized as Purchase Prepayments on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Purchase Prepayments (Level 3 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Shareholders equity
Formula
The Shareholders Equity measure calculates the #balance-at-date for general ledger accounts categorized as Common Stock on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Shareholder's Equity (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
It multiplies the balance by -1 to reverse the sign of credit balances.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Working capital
Formula
#current-assets - #current-liabilities
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
## Income statement measures
The Revenue, Interest Revenue, FX Gains Revenue, and Extraordinary Revenue measures multiply the underlying net change by -1 to reverse the sign of credit balances. Their Balance at Date and Beginning Balance variants apply the same sign reversal to the corresponding balances.
 #cost-of-goods-sold
 #depreciation-and-amortization
 #expense
 #expense-balance-at-date
 #expense-beginning-balance
 #extraordinary-expense
 #extraordinary-expense-balance-at-date
 #extraordinary-expense-beginning-balance
 #extraordinary-revenue
 #extraordinary-revenue-balance-at-date
 #extraordinary-revenue-beginning-balance
 #fx-gains-revenue
 #fx-gains-revenue-balance-at-date
 #fx-gains-revenue-beginning-balance
 #fx-losses-expense
 #fx-losses-expense-balance-at-date
 #fx-losses-expense-beginning-balance
 #interest-expense
 #interest-expense-balance-at-date
 #interest-expense-beginning-balance
 #interest-revenue
 #interest-revenue-balance-at-date
 #interest-revenue-beginning-balance
 #operating-expense---opex
 #operating-expense---opex-balance-at-date
 #operating-expense---opex-beginning-balance
 #operating-revenue
 #operating-revenue-balance-at-date
 #operating-revenue-beginning-balance
 #purchases
 #revenue
 #revenue-balance-at-date
 #revenue-beginning-balance
 #tax-expense
 #tax-expense-balance-at-date
 #tax-expense-beginning-balance
### Cost of goods sold
Formula
The Cost of Goods Sold measure calculates the #net-change for general ledger accounts categorized as Cost of Goods Sold on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Cost of Goods Sold (Level 1 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Depreciation and amortization
Formula
The Depreciation and Amortization measure calculates the #net-change for general ledger accounts categorized as Depreciation and Amortization on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Depreciation and Amortization Expense (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Expense
Formula
The Expense measure calculates the #net-change for general ledger accounts categorized as Expense on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Expense (Level 1 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Expense (balance at date)
Formula
The Expense measure calculates the #balance-at-date for general ledger accounts categorized as Expense on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Expense (Level 1 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Expense (beginning balance)
Formula
The Expense (Beginning Balance) measure calculates #expense-balance-at-date using dates strictly before the first selected date.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Extraordinary expense
Formula
The Extraordinary Expense measure calculates the #net-change for general ledger accounts categorized as Extraordinary Expense on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Extraordinary Expense (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Extraordinary expense (balance at date)
Formula
The Extraordinary Expense (Balance at Date) measure calculates the #balance-at-date for general ledger accounts categorized as Extraordinary Expense on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Extraordinary Expense (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Extraordinary expense (beginning balance)
Formula
The Extraordinary Expense (Beginning Balance) measure calculates #extraordinary-expense-balance-at-date using dates strictly before the first selected date.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Extraordinary revenue
Formula
The Extraordinary Revenue measure calculates the #net-change for general ledger accounts categorized as Extraordinary Revenue on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Extraordinary Revenue (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page. It then multiplies the result by -1 to display the balance as a positive value.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Extraordinary revenue (balance at date)
Formula
The Extraordinary Revenue (Balance at Date) measure calculates the #balance-at-date for general ledger accounts categorized as Extraordinary Revenue on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Extraordinary Revenue (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page. It then multiplies the result by -1 to display the balance as a positive value.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Extraordinary revenue (beginning balance)
Formula
The Extraordinary Revenue (Beginning Balance) measure calculates #extraordinary-revenue-balance-at-date using dates strictly before the first selected date, including the revenue sign reversal.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### FX gains revenue
Formula
The FX Gains Revenue measure calculates the #net-change for general ledger accounts categorized as FX Gains Revenue on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the FX Gains Revenue (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### FX gains revenue (balance at date)
Formula
The FX Gains Revenue measure calculates the #balance-at-date for general ledger accounts categorized as FX Gains Revenue on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the FX Gains Revenue (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### FX gains revenue (beginning balance)
Formula
The FX Gains Revenue (Beginning Balance) measure calculates #fx-gains-revenue-balance-at-date using dates strictly before the first selected date, including the revenue sign reversal.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### FX losses expense
Formula
The FX Losses Expense measure calculates the #net-change for general ledger accounts categorized as FX Losses Expense on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the FX Losses (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### FX losses expense (balance at date)
Formula
The FX Losses Expense measure calculates the #balance-at-date for general ledger accounts categorized as FX Losses Expense on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the FX Losses Expense (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### FX losses expense (beginning balance)
Formula
The FX Losses Expense (Beginning Balance) measure calculates #fx-losses-expense-balance-at-date using dates strictly before the first selected date.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Interest expense
Formula
The Interest Expense measure calculates the #net-change for general ledger accounts categorized as Interest Expense on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Interest Expense (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Interest expense (balance at date)
Formula
The Interest Expense measure calculates the #balance-at-date for general ledger accounts categorized as Interest Expense on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Interest Expense (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Interest expense (beginning balance)
Formula
The Interest Expense (Beginning Balance) measure calculates #interest-expense-balance-at-date using dates strictly before the first selected date.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Interest revenue
Formula
The Interest Revenue measure calculates the #net-change for general ledger accounts categorized as Income, Interest on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Interest Revenue (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Interest revenue (balance at date)
Formula
The Interest Revenue measure calculates the #balance-at-date for general ledger accounts categorized as Income, Interest on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Interest Revenue (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Interest revenue (beginning balance)
Formula
The Interest Revenue (Beginning Balance) measure calculates #interest-revenue-balance-at-date using dates strictly before the first selected date, including the revenue sign reversal.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Operating expense - OPEX
Formula
#expense - #interest-expense - #fx-losses-expense - #tax-expense - #extraordinary-expense
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Operating expense - OPEX (balance at date)
Formula
#expense-balance-at-date - #interest-expense-balance-at-date - #fx-losses-expense-balance-at-date - #tax-expense-balance-at-date - #extraordinary-expense-balance-at-date
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Operating expense - OPEX (beginning balance)
Formula
#expense-beginning-balance - #interest-expense-beginning-balance - #fx-losses-expense-beginning-balance - #tax-expense-beginning-balance - #extraordinary-expense-beginning-balance
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Operating revenue
Formula
#revenue - #interest-revenue - #fx-gains-revenue - #extraordinary-revenue
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Operating revenue (balance at date)
Formula
#revenue-balance-at-date - #interest-revenue-balance-at-date - #fx-gains-revenue-balance-at-date - #extraordinary-revenue-balance-at-date
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Operating revenue (beginning balance)
Formula
#revenue-beginning-balance - #interest-revenue-beginning-balance - #fx-gains-revenue-beginning-balance - #extraordinary-revenue-beginning-balance
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Purchases
Formula
The Purchases measure calculates the #net-change for general ledger accounts categorized as Purchases on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Purchases (Level 3 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Revenue
Formula
The Revenue measure calculates the #net-change for general ledger accounts categorized as Income on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Revenue (Level 1 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Revenue (balance at date)
Formula
The Revenue measure calculates the #balance-at-date for general ledger accounts categorized as Income on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Revenue (Level 1 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Revenue (beginning balance)
Formula
The Revenue (Beginning Balance) measure calculates #revenue-balance-at-date using dates strictly before the first selected date, including the revenue sign reversal.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Tax expense
Formula
The Tax Expense measure calculates the #net-change for general ledger accounts categorized as Tax Expense on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Tax Expense (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Tax expense (balance at date)
Formula
The Tax Expense measure calculates the #balance-at-date for general ledger accounts categorized as Tax Expense on the G/L Account Category<https://businesscentral.dynamics.com?page=790> page and where this category is mapped to the Tax Expense (Level 2 Category) on the Power BI Account Categories<https://businesscentral.dynamics.com?page=36961> page.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Tax expense (beginning balance)
Formula
The Tax Expense (Beginning Balance) measure calculates #tax-expense-balance-at-date using dates strictly before the first selected date.
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
## Liquidity KPIs
 #cash-ratio
 #current-ratio
 #quick-ratio
### Cash ratio
Formula
#liquid-assets / #current-liabilities
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Current ratio
Formula
#current-assets / #current-liabilities
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Quick ratio
Formula
( #current-assets - #inventory - #purchase-prepayments ) / #current-liabilities
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
## Profitability KPIs
 #debt-ratio
 Debt/Equity Ratio<#debtequity-ratio>
 #ebitda
 #gross-profit
 #gross-profit-margin
 #net-profit
 #net-profit-margin
 #operating-profit---ebit
 #operating-profit---ebit-balance-at-date
 #operating-profit---ebit-beginning-balance
 #operating-profit-margin
 #return-on-assets---roa
 #return-on-capital-employed---roce
 #return-on-equity---roe
 #return-on-net-assets---rona
 #shareholder-equity-ratio
### Debt ratio
Formula
#liabilities / #assets
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Debt/equity ratio
Formula
#liabilities / Shareholder's Equity<#shareholders-equity>
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### EBITDA
Formula
#operating-profit---ebit + #depreciation-and-amortization
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Gross profit
Formula
#revenue - #cost-of-goods-sold
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Gross profit margin
Formula
#gross-profit / #revenue
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Net profit
Formula
#revenue - #cost-of-goods-sold - #expense
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Net profit margin
Formula
#net-profit / #revenue
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Operating profit - EBIT
Formula
#operating-revenue - #operating-expense---opex
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Operating profit - EBIT (balance at date)
Formula
#operating-revenue-balance-at-date - #operating-expense---opex-balance-at-date
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Operating profit - EBIT (beginning balance)
Formula
#operating-revenue-beginning-balance - #operating-expense---opex-beginning-balance
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Operating profit margin
Formula
#operating-profit---ebit / #operating-revenue
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Return on assets - ROA
Formula
#net-profit / #assets
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Return on capital employed - ROCE
Formula
#operating-profit---ebit / #capital-employed
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Return on equity - ROE
Formula
#net-profit / Shareholder's Equity<#shareholders-equity>
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Return on net assets - RONA
Formula
#net-profit / ( #fixed-assets + #working-capital )
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
### Shareholder equity ratio
Formula
Shareholder's Equity<#shareholders-equity> / #assets
Data Sources
 G/L Entry
 G/L Account Category
 Account Categories
## Customer ledger measures
The Customer Ledger Entries model table combines detailed customer ledger entries with their customer ledger entries. Amounts come from detailed entries, so a payment document can contribute multiple rows.
 #bucket-1-receivables
 #bucket-2-receivables
 #bucket-3-receivables
 #bucket-4-receivables
 #current-receivables
 #amount-receivable-lcy
 #balance-accounts-receivable
 #original-amount-lcy
 #late-payment-amount
 #late-payment-percent
 #average-days-late
 #no-of-payments
 #no-of-late-payments
### Bucket 1 (receivables)
Formula
The Bucket 1 (Receivables) measure calculates the #amount-receivable-lcy within the first aging bucket using the selected due date, posting date, or document date basis. The bucket ends one day before the latest selected date and spans the number of days in Aging Bucket Period.
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
### Bucket 2 (receivables)
Formula
The Bucket 2 (Receivables) measure calculates the #amount-receivable-lcy in the period immediately before Bucket 1. It uses Aging Bucket Period, the latest selected date, and the selected due date, posting date, or document date basis.
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
 Date
### Bucket 3 (receivables)
Formula
The Bucket 3 (Receivables) measure calculates the #amount-receivable-lcy in the period immediately before Bucket 2. It uses Aging Bucket Period, the latest selected date, and the selected due date, posting date, or document date basis.
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
 Date
### Bucket 4 (receivables)
Formula
The Bucket 4 (Receivables) measure calculates the #amount-receivable-lcy for dates earlier than Bucket 3. It includes all older dates, rather than one fixed-length period, using the selected due date, posting date, or document date basis.
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
 Date
### Current (receivables)
Formula
The Current (Receivables) measure calculates the #amount-receivable-lcy where the selected due date, posting date, or document date is on or after the latest selected date.
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
 Date
### Amount receivable (LCY)
Formula
The Amount Receivable (LCY) measure calculates the total amount of receivables in the local currency for a given period. The measure sums up the amount (in local currency) of the Customer Ledger Entries table to determine the total amount of receivables.
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
### Balance (accounts receivable)
Formula
The Balance (Accounts Receivable) measure calculates the total balance of accounts receivable up to a specific date. The measure uses the #amount-receivable-lcy measure and applies a filter to only include transactions on or before the selected date.
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
 Date
### Original amount (LCY)
Formula
The Original Amount (LCY) measure calculates the total amount of original entries for customers in the local currency. The measure sums up the amount (in local currency) of the Customer Ledger Entries table, but only includes entries with the entry type of "Initial Entry".
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
### Late payment amount
Formula
The Late Payment Amount measure sums Amount (LCY) in the Customer Ledger Entries model table for payments where the detailed entry's posting date exceeds the customer ledger entry's due date, then multiplies the result by -1.
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
### Late payment percent
Formula
The Late Payment % measure calculates the #no-of-late-payments divided by the total #no-of-payments.
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
### Average days late
Formula
The Average Days Late measure calculates the average number of days between the Due Date and Posting Date, where Document Type is Payment and Posting Date exceeds Due Date.
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
### No. of payments
Formula
The No. of Payments measure calculates a distinct count of Document No. where Document Type is Payment. It removes filters on the Late Payment column.
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
### No. of late payments
Formula
The No. of Late Payments measure counts rows in the Customer Ledger Entries model table where Document Type is Payment and the detailed entry's posting date exceeds the customer ledger entry's due date. Unlike No. of Payments, it doesn't count distinct document numbers.
Data Sources
 Customer Ledger Entry
 Detailed Customer Ledger Entry
## Vendor ledger measures
The Vendor Ledger Entries model table combines detailed vendor ledger entries with their vendor ledger entries. Amounts come from detailed entries.
 #bucket-1-payables
 #bucket-2-payables
 #bucket-3-payables
 #bucket-4-payables
 #current-payables
 #amount-payable-lcy
 #balance-accounts-payable
 #original-amount
### Bucket 1 (payables)
Formula
The Bucket 1 (Payables) measure calculates the #amount-payable-lcy within the first aging bucket using the selected due date, posting date, or document date basis. The bucket ends one day before the latest selected date and spans the number of days in Aging Bucket Period.
Data Sources
 Vendor Ledger Entry
 Detailed Vendor Ledger Entry
 Date
### Bucket 2 (payables)
Formula
The Bucket 2 (Payables) measure calculates the #amount-payable-lcy in the period immediately before Bucket 1. It uses Aging Bucket Period, the latest selected date, and the selected due date, posting date, or document date basis.
Data Sources
 Vendor Ledger Entry
 Detailed Vendor Ledger Entry
 Date
### Bucket 3 (payables)
Formula
The Bucket 3 (Payables) measure calculates the #amount-payable-lcy in the period immediately before Bucket 2. It uses Aging Bucket Period, the latest selected date, and the selected due date, posting date, or document date basis.
Data Sources
 Vendor Ledger Entry
 Detailed Vendor Ledger Entry
 Date
### Bucket 4 (payables)
Formula
The Bucket 4 (Payables) measure calculates the #amount-payable-lcy for dates earlier than Bucket 3. It includes all older dates, rather than one fixed-length period, using the selected due date, posting date, or document date basis.
Data Sources
 Vendor Ledger Entry
 Detailed Vendor Ledger Entry
 Date
### Current (payables)
Formula
The Current (Payables) measure calculates the #amount-payable-lcy where the selected due date, posting date, or document date is on or after the latest selected date.
Data Sources
 Vendor Ledger Entry
 Detailed Vendor Ledger Entry
 Date
### Amount payable (LCY)
Formula
The Amount Payable (LCY) measure calculates the total amount of payables in the local currency for a given period. The measure sums up the values in the amount (in local currency) column of the Vendor Ledger Entry table to determine the total amount of payables.
Data Sources
 Vendor Ledger Entry
 Detailed Vendor Ledger Entry
 Date
### Balance (accounts payable)
Formula
The Balance (Accounts Payable) measure calculates the total balance of accounts payable up to a specific date. The measure uses the #amount-payable-lcy measure and applies a filter to only include transactions on or before the selected date.
Data Sources
 Vendor Ledger Entry
 Detailed Vendor Ledger Entry
### Original amount
Formula
The Original Amount measure calculates the total amount of original entries for vendors. The measure uses the #amount-payable-lcy measure and applies a filter to the Vendor Ledger Entries table to only include entries with the Entry Type equal to "Initial Entry".
Data Sources
 Vendor Ledger Entry
 Detailed Vendor Ledger Entry
## G/L entry measures
 #amount
 #balance
 #balance-at-date
 #balance-at-date-neg
 #net-change
 #net-change-neg
 #variance-to-budget
 #variance-to-budget-
### Amount
Formula
The Amount measure sums all values in the amount column of the G/L Entry table.
Data Sources
 G/L Entry
### Balance
Formula
The Balance measure calculates the total #amount across all dates, ignoring any filters on the Date table. By removing date-based filtering, this measure provides the full balance from the start to the end of the dataset, regardless of any date selections applied in the report.
Data Sources
 G/L Entry
### Balance at date
Formula
The Balance at Date measure calculates the cumulative #amount up to the latest date in the current filter context. It removes all date filters, then re-applies a filter to include only dates up to and including the maximum date within the selection. This provides a running balance up to the specified date.
Data Sources
 G/L Entry
### Balance at date (neg)
Formula
The Balance at Date (Neg) measure, abbreviated for Balance at Date (Negative), shows the #balance-at-date measure as a negative value.
Balance at Date (Neg) = #balance-at-date x -1
Data Sources
 G/L Entry
### Net change
Formula
The Net Change measure is a filtered version of #amount, focusing on non-closing entries to show only the net activity. Net Change filters out entries where Closing Entry is TRUE, excluding closing entries from its calculation.
Data Sources
 G/L Entry
### Net change (neg)
Formula
The Net Change (Neg) measure, abbreviated for Net Change (Negative), shows the #net-change measure as a negative value.
Net Change (Neg) = #net-change x -1
Data Sources
 G/L Entry
### Variance to budget
Formula
The Variance to Budget measure calculates the difference between the actual net change and the budget amount.
Variance to Budget = #net-change - #budget-amount
Data Sources
 G/L Entry
 G/L Budget Entry
### Variance to budget %
Formula
Variance to Budget % = #variance-to-budget / #net-change
Data Sources
 G/L Entry
 G/L Budget Entry
## G/L budget entry measures
 #budget-amount
 #budget-balance-at-date
### Budget amount
Formula
The Budget Amount measure sums up all the budgeted amounts from the G/L Budget Entry table.
Data Sources
 G/L Budget Entry
### Budget balance at date
Formula
The Budget Balance at Date measure calculates the budgeted balance at a specific date.
Data Sources
 G/L Budget Entry
## Related information
Track your business KPIs with Power BI goals<track-kpis-with-power-bi-metrics>
Power BI finance app<finance-powerbi-app>
Ad hoc analysis on finance data<ad-hoc-analysis-finance>
Built-in core finance reports<finance-reports>
Built-in fixed assets reports<fa-reports>
Built-in accounts receivable reports<receivables-reports>
Built-in accounts payable reports<payables-reports>
Financial analytics overview<bi>
Finance overview<finance>
Find free e-learning modules for Business Central here<https://learn.microsoft.com/training/dynamics365/business-central>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/finance-powerbi-kpis, MicrosoftDocs/dynamics365smb-docs at 46907ac (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/finance-powerbi-kpis/
