# Power BI Purchases app KPIs and measures
> APPLIES TO: Generally available in Business Central 2024 release wave 2.
This article describes key performance indicators (KPIs) and measures in the semantic model for the Power BI Purchases app. Sections marked as deprecated describe older versions of the model.
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. See Track your business KPIs with Power BI metrics<track-kpis-with-power-bi-metrics>.
## Budget measures
 #budget-amount
 #budget-amount-variance
 #budget-amount-variance-
 #budget-quantity
 #budget-quantity-variance
 #budget-quantity-variance-
### Budget amount
Formula
The Budget Amount measure sums the Cost Amount column from the Purchase Budget table.
Data Sources
 Item Budget Entries
### Budget amount variance
Formula
Budget Amount Variance = #purchase-lcy - #budget-amount
Data Sources
 Item Budget Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Value Entry
### Budget amount variance %
Formula
Budget Amount Variance % = #budget-amount-variance / #budget-amount
Data Sources
 Item Budget Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Value Entry
### Budget quantity
Formula
The Budget Quantity measure sums the Quantity column from the Purchase Budget table.
Data Sources
 Item Budget Entry
### Budget quantity variance
Formula
Budget Quantity Variance = #purchase-quantity - #budget-quantity
Data Sources
 Item Budget Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Value Entry
### Budget quantity variance %
Formula
Budget Quantity Variance % = #budget-quantity-variance / #budget-quantity
Data Sources
 Item Budget Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Value Entry
## Documents
 #invoiced-prepayment-amount-lcy
 #purchase-lcy
 #purchase-lcy-forecasting
 #purchase-quantity
 #return-rate-amount
 #return-rate-qty
 #total-credit-amount
 #total-credit-qty
 #total-purchase-amount
 #total-purchase-qty
### Purchase amount
> NOTE
> This measure is deprecated in Business Central 2025 release wave 2 and is no longer available.
Formula
The Purchase Amount measure sums the Purchase Amount column of the Purchases table.
Data Sources
 Value Entry
### Purchase quantity
Formula
The Purchase Quantity measure adds #purchase-value-entries-quantity, #purchase-invoice-line-quantity-base, and #purchase-credit-line-quantity-base. The measure returns a blank value when the total is zero.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Purchase (LCY)
Formula
The Purchase (LCY) measure calculates the purchase amount across all invoiced purchase transactions by calculating the sum of #purchase-value-entries-amount, #purchase-credit-line-amount and #purchase-invoice-line-amount. Reconcile this measure to the Vendor Statistics page.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Purchase (LCY) forecasting
Formula
The Purchase (LCY) Forecasting measure calculates the #purchase-lcy within the period of dates with purchase transactions and inserts zero values for dates without purchase entries, for compatibility with forecasting.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Return rate (amount)
Formula
Return Rate (Amount) = - #total-credit-amount / #total-purchase-amount
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Return rate (qty.)
Formula
Return Rate (Qty.) = - #total-credit-qty / #total-purchase-qty
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Total credit (amount)
Formula
Total Credit (Amount) = Posted Purchase CR/Adj Note Amount<#posted-purchase-cradj-note-amount> + #purchase-credit-line-amount
Data Sources
 Value Entry
 Purchase Credit Memo Line
### Total credit (qty.)
Formula
Total Credit (Qty.)= Posted Purchase CR/Adj Note Quantity<#posted-purchase-cradj-note-quantity> + #purchase-credit-line-quantity-base
Data Sources
 Value Entry
 Purchase Credit Memo Line
### Total purchase (amount)
Formula
Total Purchase (Amount) = #posted-purchase-invoice-amount + #purchase-invoice-line-amount
Data Sources
 Value Entry
 Purchase Invoice Line
### Total purchase (qty.)
Formula
Total Purchase (Qty.)= #posted-purchase-invoice-quantity + #purchase-invoice-line-quantity-base
Data Sources
 Value Entry
 Purchase Invoice Line
### Invoiced prepayment amount (LCY)
Formula
The Invoiced Prepayment Amount (LCY) measure calculates the sum of the Prepayment Amount Invoiced (LCY) from the Purchase Lines table.
Data Sources
 Purchase Line
## Purchase value entries
 Counters
   #no-of-distinct-items
   #no-of-posted-purchase-invoices
   #no-of-single-supplier-items
   #no-of-vendors
 Purchase Invoice
   #posted-purchase-invoice-amount
   #posted-purchase-invoice-quantity
 Purchase CR/Adj Note
   Posted Purchase CR/Adj Note Amount<#posted-purchase-cradj-note-amount>
   Posted Purchase CR/Adj Note Quantity<#posted-purchase-cradj-note-quantity>
 #purchase-value-entries-amount
 #purchase-value-entries-discount-
 #purchase-value-entries-discount-amount
 #purchase-value-entries-quantity
### No. of distinct items
Formula
The No. of Distinct Items calculates the number of unique items that have been purchased by counting the distinct values of the Item No. column of the Purchase Value Entry table.
Data Sources
 Value Entry
### No. of posted purchase invoices
Formula
The No. of Posted Purchase Invoices measure counts distinct values of Document No. in the Purchase Value Entries table where Document Type is Posted Purchase Invoice.
Data Sources
 Value Entry
### No. of purchase invoices
> NOTE
> This measure is deprecated in Business Central 2025 release wave 2 and is no longer available.
Formula
The No. of Purchase Invoices measure calculates the number of unique posted purchase invoices by counting the distinct count of the Document No. column from the Purchases table where Document Type = Purchase Invoice and Source Type = Value Entries Invoiced.
Data Sources
 Purchase Line
 Value Entry
### No. of vendors
Formula
The No. of Vendors measure counts distinct values of the Vendor No. column in the Purchase Value Entries table.
Data Sources
 Value Entry
### No. of single supplier items
Formula
The No. of Single-Supplier Items measure counts items for which #no-of-vendors equals one.
Data Sources
 Value Entry
### Posted purchase invoice amount
Formula
The Posted Purchase Invoice Amount calculates the total cost amount that has been purchased and invoiced, by summing the Purchase Value Entries Amount column of the Purchase Value Entries table, where Document Type = Posted Purchase Invoice.
Data Sources
 Value Entry
### Posted purchase invoice quantity
Formula
The Posted Purchase Invoice Quantity calculates the total quantity that has been purchased and invoiced, by summing the Purchase Value Entries Quantity column of the Purchase Value Entries table, where Document Type = Posted Purchase Invoice.
Data Sources
 Value Entry
### Invoiced amount
> NOTE
> This measure is deprecated in Business Central 2025 release wave 2 and is no longer available.
Formula
The Invoiced Amount calculates the total amount of items that have been purchased and invoiced, by summing the Purchase Amount column of the Purchases table, where Source Type = Purchase Value Entries Invoiced.
Data Sources
 Value Entry
### Invoiced quantity
> NOTE
> This measure is deprecated in Business Central 2025 release wave 2 and is no longer available.
Formula
The Invoiced Quantity measure calculates the total quantity of items that have been purchased and invoiced, by summing the Purchase Quantity column of the Purchases table, where Source Type = Purchase Value Entries Invoiced.
Data Sources
 Value Entry
### Posted purchase CR/Adj note amount
Formula
The Posted Purchase CR/Adj Note Amount calculates the total cost amount that has been credited and invoiced, by summing the Purchase Value Entries Amount column of the Purchase Value Entries table, where Document Type = Posted Purchase CR/Adj Note.
Data Sources
 Value Entry
### Posted purchase CR/Adj note quantity
Formula
The Posted Purchase CR/Adj Note Quantity calculates the total quantity that has been credited and invoiced, by summing the Purchase Value Entries Quantity column of the Purchase Value Entries table, where Document Type = Posted Purchase CR/Adj Note.
Data Sources
 Value Entry
### Purchase value entries amount
Formula
The Purchase Value Entries Amount calculates the total amount that has been purchased, by summing the Cost Amount Actual column of the Purchase Value Entries table, where Value Entry Type = Direct Cost and Adjustment is false.
Data Sources
 Value Entry
### Purchase value entries quantity
Formula
The Purchase Value Entries Quantity calculates the total quantity that has been purchased and invoiced, by summing the Invoiced Quantity column of the Purchase Value Entries table.
Data Sources
 Value Entry
### Purchase value entries discount amount
Formula
The Purchase Value Entries Discount Amount measure sums the discountAmount column of the Purchase Value Entries table.
Data Sources
 Value Entry
### Purchase value entries discount %
Formula
Purchase Value Entries Discount % = #purchase-value-entries-discount-amount / #purchase-value-entries-amount
Data Sources
 Value Entry
## Purchase lines
 Counters
   #no-of-outstanding-invoices
   #no-of-outstanding-purchase-orders
   #no-of-outstanding-return-orders
   #no-of-purchase-quotes
   #no-of-received-not-invd-purchase-orders
 Outstanding
   #outstanding-invoices-lcy
   #outstanding-orders-lcy
 Quote
   #purchase-quote-purchase-lcy
   #purchase-quote-quantity
 Received Not Invoiced
   #amt-rcd-not-invoiced-lcy
 Return Order
   #outstanding-return-order-lcy
   #return-order-amount
   #return-order-quantity
   #return-qty-invoiced
   #return-qty-shipped
   #return-qty-to-invoice
   #return-qty-to-ship
   #returned-quantity
### No. of outstanding invoices
Formula
The No. of Outstanding Invoices measure counts distinct document numbers in the Purchase Lines table where Document Type is Invoice and outstandingQtyBase isn't zero.
Data Sources
 Purchase Line
### No. of outstanding purchase orders
Formula
The No. of Outstanding Purchase Orders measure counts distinct document numbers in the Purchase Lines table where Document Type is Order and outstandingQtyBase isn't zero.
Data Sources
 Purchase Line
### No. of outstanding return orders
Formula
The No. of Outstanding Return Orders measure counts distinct document numbers in the Purchase Lines table where Document Type is Return Order and outstandingQtyBase isn't zero.
Data Sources
 Purchase Line
### No. of purchase quotes
Formula
The No. of Purchase Quotes calculates the number of unique purchase quotes, by counting the distinct values of the Document No. column of the Purchase Lines table, where Document Type = Quote.
Data Sources
 Purchase Line
### No. of received not invd. purchase orders
Formula
The No. of Received Not Invoiced Purchase Orders measure counts distinct document numbers in the Purchase Lines table where Document Type is Order and qtyReceived isn't zero. The calculation doesn't test whether the received quantity has been invoiced.
Data Sources
 Purchase Line
### Outstanding invoices (LCY)
Formula
The Outstanding Invoices (LCY) measure calculates the sum of the Outstanding Amount (LCY) column from the Purchase Line table where Document Type = Invoice.
Data Sources
 Purchase Line
### Outstanding orders (LCY)
Formula
The Outstanding Orders (LCY) measure calculates the sum of the Outstanding Amount (LCY) column from the Purchase Line table where Document Type = Order.
Data Sources
 Purchase Line
### Outstanding amount (excl. VAT)
> NOTE
> This measure is deprecated in Business Central 2025 release wave 2 and is no longer available.
Formula
The Outstanding Amount (Excl. VAT) measure calculates the sum of Purchase Amount column from the Purchases table where Source Type = Purchase Order Outstanding, excluding VAT.
Data Sources
 Purchase Line
### Outstanding quantity
> NOTE
> This measure is deprecated in Business Central 2025 release wave 2 and is no longer available.
Formula
The Outstanding Quantity measure calculates the sum of Purchase Qty. (Base) column from the Purchases table where Source Type = Purchase Order Outstanding.
Data Sources
 Purchase Line
### Purchase quote purchase (LCY)
Formula
The Purchase Quote Purchase (LCY) measure calculates the sum of the Outstanding Amount (LCY) column from the Purchase Line table where Document Type = Quote.
Data Sources
 Purchase Line
### Purchase quote quantity
Formula
The Purchase Quote Quantity measure calculates the sum of the Outstanding Quantity (Base) column from the Purchase Line table where Document Type = Quote.
Data Sources
 Purchase Line
### Amt. rcd. not invoiced (LCY)
Formula
The Amt. Rcd. Not Invoiced (LCY) measure calculates the sum of the Amount Received Not Invoiced (LCY) column from the Purchase Line table where Document Type = Order.
Data Sources
 Purchase Line
### Amt. rcd. not invd. (excl. VAT)
> NOTE
> This measure is deprecated in Business Central 2025 release wave 2 and is no longer available.
Formula
The Amt. Rcd. Not Invd. (Excl. VAT) measure calculates the sum of Purchase Amount column from the Purchases table where Source Type = Purchase Order Received Not Invoiced, excluding VAT.
Data Sources
 Purchase Line
### Quantity rcd. not invd.
> NOTE
> This measure is deprecated in Business Central 2025 release wave 2 and is no longer available.
Formula
The Quantity Rcd. Not Invd. measure calculates the sum of Purchase Qty. (Base) column from the Purchases table. where Source Type = Purchase Order Received Not Invoiced.
Data Sources
 Purchase Line
### Outstanding return order (LCY)
Formula
The Outstanding Return Order (LCY) measure calculates the sum of the Outstanding Amount (LCY) column from the Purchase Line table where Document Type = Return Order or Cr/Adj Note.
Data Sources
 Purchase Line
### Return order amount
Formula
The Return Order Amount measure calculates the sum of the Amount column from the Purchase Line table where Document Type = Return Order or Cr/Adj Note.
Data Sources
 Purchase Line
### Return order quantity
Formula
The Return Order Quantity measure calculates the sum of the Quantity (Base) column from the Purchase Line table where Document Type = Return Order or Cr/Adj Note.
Data Sources
 Purchase Line
### Return qty. invoiced
Formula
The Return Qty. Invoiced measure calculates the negative sum of the quantityInvoiced column from the Purchase Lines table where Document Type is Return Order or Cr/Adj Note.
Data Sources
 Purchase Line
### Return qty. shipped
Formula
Return Qty. Shipped = #return-order-quantity - #return-qty-to-ship
Data Sources
 Purchase Line
### Return qty. to invoice
Formula
Return Qty. to Invoice = #return-order-quantity - #return-qty-invoiced
Data Sources
 Purchase Line
### Return qty. to ship
Formula
The Return Qty. to Ship measure calculates the sum of the Outstanding Quantity (Base) column from the Purchase Line table where Document Type = Return Order or Cr/Adj Note.
Data Sources
 Purchase Line
### Returned quantity
Formula
Returned Quantity = Posted Purchase CR/Adj Note Quantity<#posted-purchase-cradj-note-quantity> + #return-qty-to-invoice
Data Sources
 Purchase Line
 Value Entry
## Purchase credit lines
 #purchase-credit-line-amount
 #purchase-credit-line-quantity-base
### Purchase credit line amount
Formula
The Purchase Credit Line Amount measure calculates the negative sum of the Amount column from the Purchase Credit Line table.
Data Sources
 Purchase Credit Memo Line
### Purchase credit line quantity base
Formula
The Purchase Credit Line Quantity Base measure calculates the sum of the Quantity Base column from the Purchase Credit Line table.
Data Sources
 Purchase Credit Memo Line
## Purchase invoice lines
 #purchase-invoice-line-amount
 #purchase-invoice-line-quantity-base
### Purchase invoice line amount
Formula
The Purchase Invoice Line Amount measure calculates the sum of the Amount column from the Purchase Invoice Line table.
Data Sources
 Purchase Invoice Line
### Purchase invoice line quantity base
Formula
The Purchase Invoice Line Quantity Base measure calculates the sum of the Quantity Base column from the Purchase Invoice Line table.
Data Sources
 Purchase Invoice Line
## Pareto measures
 #pareto-color-cutoff
 #pareto-cumulative-purchase-lcy
 #pareto-cumulative-purchase-lcy-
 #pareto-cutoff-cumulative-purchase-lcy
 #pareto-cutoff-purchase-lcy-
 #pareto-cutoff-vendor
 #pareto-cutoff-vendor-rank
 #pareto-vendor-cutoff-rank
 #pareto-vendor-rank-by-purchase-lcy
 #pareto-total-purchase-lcy
### Pareto color cutoff
Formula
The color cutoff where #pareto-vendor-rank-by-purchase-lcy exceeds the #pareto-vendor-cutoff-rank.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Pareto cumulative purchase (LCY)
Formula
The #purchase-lcy based on the #pareto-vendor-rank-by-purchase-lcy.
Data Source
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Pareto cumulative purchase (LCY) %
Formula
The #pareto-cumulative-purchase-lcy divided by the #pareto-total-purchase-lcy.
Data Source
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Pareto cutoff cumulative purchase (LCY)
Formula
The #pareto-cumulative-purchase-lcy for the #pareto-cutoff-vendor.
Data Source
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Pareto cutoff purchase (LCY) %
Formula
The #pareto-cumulative-purchase-lcy- for the #pareto-cutoff-vendor.
Data Source
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Pareto cutoff vendor
Formula
The vendor whose #pareto-cumulative-purchase-lcy- is closest to the selected Pareto Value, based on the smallest absolute difference.
Data Source
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Pareto cutoff vendor rank
Formula
The #pareto-vendor-rank-by-purchase-lcy for the #pareto-cutoff-vendor.
Data Source
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Pareto vendor cutoff rank
Formula
The maximum #pareto-cutoff-vendor-rank value across all vendors.
Data Source
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Pareto vendor rank by purchase (LCY)
Formula
The Pareto Vendor Rank by Purchase (LCY) measure calculates the vendor rank, ordered by the #purchase-lcy for all purchases from the Purchase Value Entries, Purchase Credit Lines and Purchase Invoice Lines tables.
Data Source
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
### Pareto total purchase (LCY)
Formula
The total #purchase-lcy for all purchases from the Purchase Value Entries, Purchase Credit Lines and Purchase Invoice Lines tables.
Data Source
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
## Vendor measures
 #item-reliance-
 #spend-reliance-
### Item reliance %
Formula
The Item Reliance % measure calculates the proportion of transactions for an item based on either the number of unique vendors or number of unique items, from the Purchase Value Entry Table. In a Vendor context, the Item Reliance % measure is calculated as #no-of-distinct-items divided by the total #no-of-distinct-items for all vendors. In an Item context, the Item Reliance % measure is calculated as one divided by the total #no-of-vendors who have supplied the item.
Data Sources
 Value Entry
### Spend reliance %
Formula
The Spend Reliance % measure calculates the #purchase-lcy divided by the total #purchase-lcy across all vendors.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Line
## Purchase amount moving annual total
 #purchase-amount-mat-fiscal
 #purchase-amount-pymat-fiscal
 #purchase-amount-matg-fiscal
 #purchase-amount-matg--fiscal
### Purchase amount MAT (fiscal)
Formula
The Purchase Amount MAT (Fiscal) measure sums #purchase-lcy over a moving 12-month date range ending on the last date in the current context. The start date is 12 calendar months before the day after that last date.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
### Purchase amount PYMAT (fiscal)
Formula
The Purchase Amount PYMAT (Fiscal) measure calculates the total purchases for the prior 12 months based on the fiscal calendar. It then determines the maximum available date and calculates the range from 24 months prior to the last available day to 12 months prior. Using these dates, it sums the purchases amount for this period while maintaining filters for the day type and week day.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
### Purchase amount MATG (fiscal)
Formula
The Purchase Amount MATG (Fiscal) measure compares the current period's moving annual total purchases to the previous period's moving annual total purchases. If both values are not blank, it subtracts the previous period's purchases from the current period's purchases to determine the growth. The result is returned, representing the change in purchases between the two periods.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
### Purchase amount MATG % (fiscal)
Formula
Purchase Amount MATG % (Fiscal) = #purchase-amount-matg-fiscal / #purchase-amount-pymat-fiscal
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
## Purchase amount moving averages
 #purchase-amount-avg-30d-fiscal
### Purchase amount AVG 30D (fiscal)
Formula
The Purchase Amount AVG 30D (Fiscal) measure averages #purchase-lcy over the last 30 calendar days in the current context. Blank daily amounts aren't included in the average. The measure returns a value only when purchase history reaches the start of that range.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
## Purchase amount period-over-period growth
 #purchase-amount-pp-fiscal
 #purchase-amount-py-fiscal
 #purchase-amount-pop-fiscal
 #purchase-amount-pop--fiscal
 #purchase-amount-yoy-fiscal
### Purchase amount PP (fiscal)
Formula
The Purchase Amount PP (Fiscal) measure calculates the purchase amount in the previous period. The period is based on the date range you select. For example, if you select a month, the measure will show the purchase amount in the previous month.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
### Purchase amount PY (fiscal)
Formula
The Purchase Amount PY (Fiscal) measure calculates the purchase amount in the previous year.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
### Purchase amount POP (fiscal)
Formula
The Purchase Amount POP (Fiscal) measure calculates the change in purchases between the current period and the previous period. The period is based on the date range you select. For example, if you select a month, the measure will show the purchase amount period-over-period compared to the previous month.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
### Purchase amount POP % (fiscal)
Formula
Purchase Amount POP % (Fiscal) = #purchase-amount-pop-fiscal / #purchase-amount-pp-fiscal
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
### Purchase amount YOY (fiscal)
Formula
The Purchase Amount YOY (Fiscal) measure shows the purchase amount of a specific period compared to the same period in the previous year. It helps you understand whether your purchases have increased or decreased over time.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
## Purchase amount period-to-date
 #purchase-amount-ytd-fiscal
### Purchase amount YTD (fiscal)
Formula
The Purchase Amount YTD (Fiscal) measure accumulates #purchase-lcy from the start of the fiscal year through the last fiscal day in the current date context. It preserves day-type and weekday filters.
Data Sources
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
## Budget amount moving annual total
 #budget-amount-mat-fiscal
 #budget-amount-matg-fiscal
 #budget-amount-matg--fiscal
 #budget-amount-pymat-fiscal
### Budget amount MAT (fiscal)
Formula
The Budget Amount MAT (Fiscal) measure sums #budget-amount over a moving 12-month date range ending on the last date in the current context.
Data Sources
 Item Budget Entry
 Date (Fiscal Calendar)
### Budget amount MATG (fiscal)
Formula
The Budget Amount MATG (Fiscal) measure subtracts #budget-amount-pymat-fiscal from #budget-amount-mat-fiscal when both values aren't blank.
Data Sources
 Item Budget Entry
 Date (Fiscal Calendar)
### Budget amount MATG % (fiscal)
Formula
Budget Amount MATG % (Fiscal) = #budget-amount-matg-fiscal / #budget-amount-pymat-fiscal
Data Sources
 Item Budget Entry
 Date (Fiscal Calendar)
### Budget amount PYMAT (fiscal)
Formula
The Budget Amount PYMAT (Fiscal) measure sums #budget-amount over the corresponding moving 12-month date range one year before the range used by Budget Amount MAT (Fiscal).
Data Sources
 Item Budget Entry
 Date (Fiscal Calendar)
## Budget amount moving averages
 #budget-amount-avg-1y-fiscal
 #budget-amount-avg-30d-fiscal
 #budget-amount-avg-3m-fiscal
### Budget amount AVG 1Y (fiscal)
Formula
The Budget Amount AVG 1Y (Fiscal) measure averages daily budget amounts over a moving 12-month range. It uses dates flagged as having purchase data, excludes blank amounts, and requires budget history to reach the first date in the range.
Data Sources
 Item Budget Entry
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
### Budget amount AVG 30D (fiscal)
Formula
The Budget Amount AVG 30D (Fiscal) measure averages #budget-amount over the last 30 calendar days in the current context. It uses dates flagged as having purchase data, excludes blank daily amounts, and requires budget history to reach the first date in the range.
Data Sources
 Item Budget Entry
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
### Budget amount AVG 3M (fiscal)
Formula
The Budget Amount AVG 3M (Fiscal) measure averages daily budget amounts over a moving three-month range. It uses dates flagged as having purchase data, excludes blank amounts, and requires budget history to reach the first date in the range.
Data Sources
 Item Budget Entry
 Value Entry
 Purchase Invoice Line
 Purchase Credit Memo Line
 Date (Fiscal Calendar)
## Gross totals
 #-gt-purchase-amount
 #-gt-purchase-quantity
 #-gt-purchase-amount-py-fiscal
### % GT purchase amount
Formula
% GT Purchase Amount = #purchase-amount / Grand Total Purchase Amount
Data Sources
 Value Entry
 Purchase Line
 Date (Fiscal Calendar)
### % GT purchase quantity
Formula
% GT Purchase Quantity = #purchase-quantity / Grand Total Purchase Quantity
Data Sources
 Value Entry
 Purchase Line
 Date (Fiscal Calendar)
### % GT purchase amount PY (fiscal)
Formula
% GT Purchase Amount PY (Fiscal) = #purchase-amount / Grand Total Purchase Amount (Previous Year)
Data Sources
 Value Entry
 Purchase Line
 Date (Fiscal Calendar)
## Related information
Track KPIs with Power BI goals<track-kpis-with-power-bi-metrics>
Power BI Purchasing app<purchases-powerbi-app>
Ad hoc analysis of purchasing data<ad-hoc-analysis-purchasing>
Built-in purchasing reports<purchase-reports>
purchasing-analytics-overview
Purchasing overview<purchasing-manage-purchasing>
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/purchases-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/purchases-powerbi-kpis/
