Power BI Inventory Valuation app KPIs and measures

APPLIES TO: Generally available in Business Central 2024 release wave 2.

This article describes inventory valuation key performance indicators (KPIs), semantic model measures, and related balance calculations for the Power BI Inventory Valuation 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.

Value entries table

Use the following table to find each KPI or balance calculation and its corresponding semantic model measure. Calculations without standalone measures are identified in the table.

KPI or balance calculationSemantic model measure
Beginning Balance G/LBeginning Balance Cost Posted to G/L
Beginning Balance G/L (Expected)Beginning Balance Expected Cost Posted to G/L
Beginning Balance QtyBeginning Balance Qty
Beginning Balance ValueBeginning Balance Cost Amount (Actual)
Beginning Balance Value (Expected)Beginning Balance Cost Amount (Expected)
Beginning Balance Value Expected Cost IncludedBeginning Balance Cost Amount (Incl. Exp Cost)
Beginning Cost Posted to G/L (Expected)Beginning Balance Expected Cost Posted to G/L
Cost Amount (Actual)Cost Amount (Actual)
Cost Amount (Expected)Cost Amount (Expected)
Cost Posted to G/LCost Posted to G/L
Cost Posted to G/L (Expected)Expected Cost Posted to G/L
Decrease Qty.Decrease Qty.
Decrease ValueDecrease Value
Decrease Value (Expected)Decrease Value (Expected)
Decrease Value Expected Cost IncludedDecrease Value Expected Cost Included
Ending Balance Expected Cost IncludedEnding Balance Cost Amount (Incl. Exp Cost)
Ending Balance Posted to G/LEnding Balance Cost Posted to G/L
Ending Balance Posted to G/L (Expected)Ending Balance Expected Cost Posted to G/L
Ending Balance Qty.Ending Balance Qty.
Ending Balance ValueEnding Balance Cost Amount (Actual)
Ending Balance Value (Expected)Ending Balance Cost Amount (Expected)
Ending Cost Posted to G/L (Expected)Ending Balance Expected Cost Posted to G/L
Ending Cost Posted to G/L Expected Cost IncludedCalculated from other measures; no standalone measure.
Increase Value Expected Cost IncludedIncrease Value Expected Cost Included
Increases Qty.Increases Qty.
Increases ValueIncreases Value
Increases Value (Expected)Increases Value (Expected)
Invoiced QuantityInvoiced Quantity
Net Balance G/LCost Posted to G/L
Net Balance G/L (Expected)Expected Cost Posted to G/L
Net Balance QtyInvoiced Quantity
Net Balance ValueCost Amount (Actual)
Net Balance Value (Expected Included)Cost Amount (Incl. Exp Cost)
Net Balance Value (Expected)Cost Amount (Expected)
VarianceVariance Cost Posted to G/L
Variance ExpCalculated from other measures; no standalone measure.

Beginning balance G/L

Formula

  • This measure calculates the cumulative Cost Posted to G/L for dates before the earliest date in the current context, allowing visibility into costs posted up to the start of the selected period.

Data Sources

  • Value Entry

Beginning balance G/L (expected)

Formula

  • This measure calculates the cumulative Cost Posted to G/L (Expected) for dates before the earliest date in the current context, allowing visibility into costs posted up to the start of the selected period.

Data Sources

  • Value Entry

Beginning balance qty

Formula

  • This measure calculates the cumulative Invoiced Qty for dates before the earliest date in the current context, allowing visibility into quantities posted up to the start of the selected period.

Data Sources

  • Value Entry

Beginning balance value

Formula

  • This measure calculates the cumulative Cost Amount (Actual) for dates before the earliest date in the current context, providing the total value up to the start of the selected period.

Data Sources

  • Value Entry

Beginning balance value (expected)

Formula

  • This measure calculates the cumulative Cost Amount (Expected) for dates before the earliest date in the current context, providing the total expected value up to the start of the selected period.

Data Sources

  • Value Entry

Beginning balance value expected cost included

Formula
Beginning Balance Value + Beginning Balance Value (Expected)

Data Sources

  • Value Entry

Beginning cost posted to G/L (expected)

Formula

  • This measure calculates the cumulative Cost Posted to G/L (Expected) for dates before the earliest date in the current context, providing the total expected cost posted to G/L up to the start of the selected period.

Data Sources

  • Value Entry

Cost amount (actual)

Formula

  • This measure calculates the total sum of the Cost Amt. (Actual) column in the Value Entries table.

Data Sources

  • Value Entry

Cost amount (expected)

Formula

  • This measure calculates the total sum of the Cost Amt. (Expected) column in the Value Entries table.

Data Sources

  • Value Entry

Cost posted to G/L

Formula

  • This measure calculates the total sum of the Cost Posted to G/L column in the Value Entries table.

Data Sources

  • Value Entry

Cost posted to G/L (expected)

Formula

  • This measure calculates the total sum of the Expected Cost Posted to G/L column in the Value Entries table.

Data Sources

  • Value Entry

Decrease qty.

Formula

  • This measure calculates the total sum of the Invoiced Quantity column from the Value Entries table, but only for rows where the Item Ledger Entry Type is one of the following: Sale, Negative Adjustment, Consumption, or Assembly Consumption. This measure captures quantities associated with these specific entry types that represent decreases in inventory.

Data Sources

  • Value Entry

Decreases value

Formula

  • This measure calculates the total sum of the Cost Amt. (Actual) column from the Value Entries table, but only for rows where the Item Ledger Entry Type is one of the following: Sale, Negative Adjustment, Consumption, or Assembly Consumption. This measure reflects the cost associated with these specific entry types that represent decreases in inventory.

Data Sources

  • Value Entry

Decreases value (expected)

Formula

  • This measure calculates the total sum of the Cost Amt. (Expected) column from the Value Entries table, but only for rows where the Item Ledger Entry Type is one of the following: Sale, Negative Adjustment, Consumption, or Assembly Consumption. This measure reflects the expected cost associated with these specific entry types that represent decreases in inventory.

Data Sources

  • Value Entry

Decrease value expected cost included

Formula
Decrease Value + Decrease Value (Expected)

Data Sources

  • Value Entry

Ending balance expected cost included

Formula Ending Balance Value + Ending Balance Value (Expected)

Data Sources

  • Value Entry

Ending balance qty.

Formula
Beginning Balance Qty. + Net Balance Qty.

Data Sources

  • Value Entry

Ending balance value

Formula
Beginning Balance Value + Net Balance Value

Data Sources

  • Value Entry

Ending balance value (expected)

Formula
Beginning Balance Value (Expected) + Net Balance Value (Expected)

Data Sources

  • Value Entry

Ending cost posted to G/L (expected)

Formula Beginning Cost Posted to G/L (Expected) + Cost Posted to G/L (Expected)

Data Sources

  • Value Entry

Ending cost posted to G/L expected cost included

Formula Ending Balance Posted to G/L (Expected) + Ending Balance Posted to G/L

Data Sources

  • Value Entry

Increase value expected cost included

Formula Increases Value + Increases Value (Expected)

Data Sources

  • Value Entry

Increases qty.

Formula

  • This measure calculates the total sum of the Invoiced Quantity column from the Value Entries table, but only for rows where the Item Ledger Entry Type is one of the following: Purchase, Positive Adjustment, Output, or Assembly Output. This measure reflects the quantity associated with these entry types that represent increases in inventory.

Data Sources

  • Value Entry

Increases value

Formula

  • This measure calculates the total sum of the Cost Amt. (Actual) column from the Value Entries table, but only for rows where the Item Ledger Entry Type is one of the following: Purchase, Positive Adjustment, Output, or Assembly Output. This measure reflects the value associated with these entry types that represent increases in inventory value.

Data Sources

  • Value Entry

Increases value (expected)

Formula

  • This measure calculates the total sum of the Cost Amt. (Expected) column from the Value Entries table, but only for rows where the Item Ledger Entry Type is one of the following: Purchase, Positive Adjustment, Output, or Assembly Output. This measure reflects the expected value associated with these entry types that represent increases in inventory value.

Data Sources

  • Value Entry

Ending balance posted to G/L

Formula
Beginning Balance G/L + Net Balance G/L

Data Sources

  • Value Entry

Ending balance posted to G/L (expected)

Formula Beginning Balance G/L (Expected) + Net Balance G/L (Expected)

Data Sources

  • Value Entry

Invoiced quantity

Formula

  • This measure calculates the total sum of the Invoiced Quantity column from the Value Entries table.

Data Sources

  • Value Entry

Net balance G/L

Formula

  • This measure calculates the total sum of the Cost Posted to G/L column from the Value Entries table.

Data Sources

  • Value Entry

Net balance G/L (expected)

Formula

  • This measure calculates the total sum of the Expected Cost Posted to G/L column from the Value Entries table.

Data Sources

  • Value Entry

Net balance qty

Formula

  • This measure calculates the total sum of the Invoiced Quantity column from the Value Entries table.

Data Sources

  • Value Entry

Net balance value

Formula

  • This measure calculates the total sum of the Cost Amount (Actual) column from the Value Entries table.

Data Sources

  • Value Entry

Net balance value (expected included)

Formula
Ending Balance Expected Cost Included - Beginning Balance Value Expected Cost Included

Data Sources

  • Value Entry

Net balance value (expected)

Formula

  • This measure calculates the total sum of the Cost Amount (Expected) column from the Value Entries table.

Data Sources

  • Value Entry

Variance

Formula
Ending Balance Posted to G/L - Ending Balance Value

Data Sources

  • Value Entry

Variance exp

Formula
Ending Cost Posted to G/L Expected Cost Included - Ending Balance Expected Cost Included

Data Sources

  • Value Entry

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.

Track KPIs with Power BI goals
Power BI Inventory Valuation app
Ad hoc analysis of inventory data
Built-in inventory and warehouse reports
Inventory analytics overview
Inventory overview

Find free e-learning modules for Business Central here