Power BI Projects app KPIs and measures
APPLIES TO: Generally available in Business Central 2024 release wave 2 (version 25.1).
This page provides a list of all Key Performance Indicators (KPIs) included in the semantic model for the Power BI Projects report.
Explore the list of KPIs below to learn more about how they can help you achieve your business goals.
Each KPI 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. To learn more, go to Track your business KPIs with Power BI metrics.
Project Measures
% Invoiced
Formula
% Invoiced = Billable (Invoiced Price) / Billable (Total Price)
Data Sources
- Job Ledger Entry
- Job Planning Line
% Complete
Formula
% Complete = Actual (Total Cost) / Budget (Total Cost)
Data Sources
- Job Ledger Entry
- Job Planning Line
Duration (Days)
Formula
The Duration (Days) measure calculates the number of days between the earliest starting date and latest ending date for a given project in the Project table.
Data Sources
- Job
Project Count
Formula
The Project Count measure counts the total number of projects in the Project table.
Data Sources
- Job
Realization %
Formula
Realization % = Billable (Invoiced Price) / Actual (Total Price)
Data Sources
- Job Ledger Entry
Realization Variance
Formula
Realization Variance = Billable (Invoiced Price) - Actual (Total Price)
Data Sources
- Job Ledger Entry
- Job Planning Line
Tasks Count
Formula
The Tasks Count measure counts the number of rows in the Tasks table that where the Project Task Type has a value of "Posting".
Data Sources
- Job Task
Profit
Actual Profit
Formula
Actual Profit = Billable (Invoiced Price) - Actual (Total Cost)
Data Sources
- Job Ledger Entry
Actual Profit Margin %
Formula
Actual Profit Margin % = Actual Profit Margin % / Billable (Invoiced Price)
Data Sources
- Job Ledger Entry
Budget Profit
Formula
Budget Profit = - Budget (Total Price) - Budget (Total Cost)
Data Sources
- Job Ledger Entry
- Job Planning Line
Budget Profit Margin %
Formula
Budget Profit Margin % = Budget Profit / Budget (Total Price)
Data Sources
- Job Ledger Entry
- Job Planning Line
Project Ledger Measures
- Actual (Total Price)
- Billable (Invoiced Price)
- Invoiced (Total Cost)
- Invoiced (Total Price)
- Quantity
- Total Price
Actual (Total Price)
Formula
The Actual (Total Price) measure calculates the total actual cost of project entries by calculating the total price (in local currency) in the Project Ledger Entry table and selecting only those entries with an entry type of "Usage". The result of this calculation is then converted to a positive value.
Data Sources
- Job Ledger Entry
Billable (Invoiced Price)
Formula
The Billable (Invoiced Price) measure shows the total invoiced price of billable project entries by calculating the total price (in local currency) in the Project Ledger Entry table and selecting only those entries with an entry type of "Sale", which indicates that the project entry is billable.
Data Sources
- Job Ledger Entry
Invoiced (Total Cost)
Formula
The Invoiced (Total Cost) measure calculates the total cost of all project ledger entries where the entry type is "Sale" in the Project Ledger Entry table.
Data Sources
- Job Ledger Entry
Invoiced (Total Price)
Formula
The Invoiced (Total Price) measure calculates the total price of all project ledger entries where the entry type is "Sale" in the Project Ledger Entry table.
Data Sources
- Job Ledger Entry
Quantity
Formula
The Quantity measure calculates the total quantity of a product or service used in a project by summing the quantity in the Project Ledger Entry table and converting the measure to a postive value.
Data Sources
- Job Ledger Entry
Total Price
Formula
The Total Price measure calculates the total price of all project ledger entries in the Project Ledger Entry table. It uses the SUMX function to iterate over each row in the table and multiply the quantity and unit price (in local currency) columns for each row. The results of each multiplication are then summed up to produce the total price.
Data Sources
- Job Ledger Entry
Usage
- Actual (Total Cost)
- Gen. Journal Usage (Total Cost)
- Labour Usage (Total Cost)
- Material Usage (Total Cost)
Actual (Total Cost)
Formula
The Actual (Total Cost) measure calculates the total cost (in local currency) of all project ledger entries where the type is "Usage" in the Project Ledger Entry table.
Data Sources
- Job Ledger Entry
Gen. Journal Usage (Total Cost)
Formula
The Gen. Journal Usage (Total Cost) measure calculates the total cost of all project ledger entries where the type is "G/L Account" in the Project Ledger Entry table.
Data Sources
- Job Ledger Entry
Labour Usage (Total Cost)
Formula
The Labour Usage (Total Cost) measure calculates the total cost of all project ledger entries where the type is "Resource" in the Project Ledger Entry table.
Data Sources
- Job Ledger Entry
Material Usage (Total Cost)
Formula
The Material Usage (Total Cost) measure calculates the total cost of all project ledger entries where the type is "Item" in the Project Ledger Entry table.
Data Sources
- Job Ledger Entry
Planning Line Measures
- Billable (Total Cost)
- Billable (Total Price)
- Budget (Total Cost)
- Budget (Total Price)
- Planning Line Quantity
- Planning Line Total Cost (LCY)
- Planning Line Total Price (LCY)
- Total Cost Variance to Budget
- Total Cost Variance to Budget %
Billable (Total Cost)
Formula
The Billable (Total Cost) measure calculates the total cost (in local currency) of all project planning lines where the line type is "Billable" or "Both Budget and Billable" in the Project Planning Line table.
Data Sources
- Job Planning Line
Billable (Total Price)
Formula
The Billable (Total Price) measure calculates the total price (in local currency) of all project planning lines where the line type is "Billable" or "Both Budget and Billable" in the Project Planning Line table.
Data Sources
- Job Planning Line
Budget (Total Cost)
Formula
The Budget (Total Cost) measure represents the budgeted cost of resources to be used in a project by calculating the total cost (in local currency) in the Project Planning Line table and selecting only those lines with a line type of "Budget" or "Both Budget and Billable".
Data Sources
- Job Ledger Entry
Budget (Total Price)
Formula
The Budget (Total Price) measure represents the budgeted price of resources to be used in a project by calculating the total price (in local currency) in the Project Planning Line table and selecting only those lines with a line type of "Budget" or "Both Budget and Billable".
Data Sources
- Job Planning Line
Planning Line Quantity
Formula
The Planning Line Quantity measure calculates the sum of the quantity column in the Project Planning Line table.
Data Sources
- Job Planning Line
Planning Line Quantity
Formula
The Planning Line Quantity measure calculates the sum of the quantity column in the Project Planning Line table.
Data Sources
- Job Planning Line
Planning Line Total Cost (LCY)
Formula
The Planning Line Total Cost (LCY) measure calculates the total cost of all project planning lines in the Project Planning Line table. It uses the SUMX function to iterate over each row in the table and multiply the quantity and unit cost (in local currency) columns for each row. The results of each multiplication are then summed up to produce the total cost.
Data Sources
- Job Planning Line
Planning Line Total Price (LCY)
Formula
The Planning Line Total Price (LCY) measure calculates the total price of all project planning lines in the Project Planning Line table. It uses the SUMX function to iterate over each row in the table and multiply the quantity and unit price (in local currency) columns for each row. The results of each multiplication are then summed up to produce the total price.
Data Sources
- Job Planning Line
Total Cost Variance to Budget
Formula
Total Cost Variance to Budget = Actual (Total Cost) - Budget (Total Cost)
Data Sources
- Job Ledger Entry
Total Cost Variance to Budget %
Formula
Total Cost Variance to Budget % = Total Cost Variance to Budget % / Budget (Total Cost)
Data Sources
- Job Ledger Entry
Purchase Measures
Amount on PO
Formula
The Amount on PO measure calculates the sum of the amount (in local currency) column in the Purchases table.
Data Sources
- Purchase Line
Amount Rcvd. Not Invoiced
Formula
The Amount Rcvd. Not Invoiced measure calculates the total amount of purchases that have been received but not yet invoiced in the Purchases table.
Data Sources
- Purchase Line
Amount Rcvd. Not Invoiced
Formula
The Amount Rcvd. Not Invoiced measure calculates the total amount of purchases that have been received but not yet invoiced in the Purchases table.
Data Sources
- Purchase Line
Outstanding Amt. on PO
Formula
The Outstanding Amt. on PO measure calculates the total amount of outstanding purchase orders in the Purchases table.
Data Sources
- Purchase Line
Purchase Order Count
Formula
The Purchase Order Count measure calculates the total number of purchase orders in the Purchases table. It uses the CALCULATE function to filter the table and returns the distinct count of the "Document No." column for the filtered rows.
Data Sources
- Purchase Line
Quantity on PO
Formula
The Quantity on PO measure calculates the total quantity of items ordered in the Purchases table. It uses the SUM function to add up all the values in the Quantity (Base) column and returns the result.
Data Sources
- Purchase Line
See also
Track your business KPIs with Power BI metrics
Power BI Projects app
Built-in Projects reports
Project management overview