Measure Summary
This reference lists the DAX measures included in the prepared QQube Inventory examples for Power BI and Excel Power Pivot. The measures support inventory quantities, values, availability, builds, sales, purchases, customer activity, and vendor activity.
Data Model Inventory | Reference Type DAX measure reference |
Visible Measures 345 | Display Folders 8 |
Measure Names Names are shown exactly as they appear in the model. Hidden measures are not included. | |
One measure is not assigned to a display folder.
.BOM Quantity remains visible in the model and is included in this reference.
DAX formulas and methodology
For the calculation methods and supporting patterns used in QQube, see DAX Methods Used in PowerPivot and Power BI.
Measure Sections
The measures are grouped below according to their placement in Power BI and Excel Power Pivot.
- Measures Without a Display Folder (1 measure)
- .Base Measures (51 measures)
- Amount Measures (4 measures)
- Calendar Pattern Measures (105 measures)
- Customer Measures (24 measures)
- Inventory Measures (15 measures)
- Item Measures (2 measures)
- Quantity Measures (137 measures)
- Vendor Measures (6 measures)
Measures Without a Display Folder
The visible BOM Quantity measure is not assigned to a display folder in the model.
| Measure Name |
|---|
| .BOM Quantity |
.Base Measures
Base calculations for inventory quantities, values, sales, purchases, adjustments, builds, consumption, COGS, and related inventory activity.
| Measure Name |
|---|
| .Line Adjustment Amount |
| .Line Adjustment Quantity |
| .Line COGS Amount |
| .Line Completed Builds Amount |
| .Line Completed Builds Quantity |
| .Line Consumption Amount |
| .Line Consumption Quantity |
| .Line Consumption Quantity Printed |
| .Line Exchange Rate |
| .Line Forecast Amount |
| .Line Forecast Quantity |
| .Line Forecast Quantity Printed |
| .Line Inventory Quantity |
| .Line Inventory Quantity Printed |
| .Line Inventory Valuation Amount |
| .Line Open Amount |
| .Line Paid Amount |
| .Line Pending Builds Amount |
| .Line Pending Builds Quantity |
| .Line Pending Builds Quantity Printed |
| .Line Purchase Amount |
| .Line Purchase Order Open Amount |
| .Line Purchase Order Open Quantity |
| .Line Purchase Order Open Quantity Printed |
| .Line Purchase Order Original Amount |
| .Line Purchase Order Original Quantity |
| .Line Purchase Order Original Quantity Printed |
| .Line Purchase Quantity |
| .Line Rate |
| .Line Rate Foreign |
| .Line Rate Percent |
| .Line Rate Printed |
| .Line Rate Sales |
| .Line Sales Amount |
| .Line Sales Order Initial Invoiced Quantity |
| .Line Sales Order Invoiced Amount |
| .Line Sales Order Invoiced Amount Actual |
| .Line Sales Order Invoiced Quantity |
| .Line Sales Order Invoiced Quantity Printed |
| .Line Sales Order Open Amount |
| .Line Sales Order Open Amount Actual |
| .Line Sales Order Open Quantity |
| .Line Sales Order Open Quantity Printed |
| .Line Sales Order Original Amount |
| .Line Sales Order Original Quantity |
| .Line Sales Order Original Quantity Printed |
| .Line Sales Profit Margin Amount |
| .Line Sales Quantity |
| .Line Sales Quantity Printed |
| .Line Transfer Amount |
| .Line Transfer Quantity |
Amount Measures
Recent-period sales and cost-of-goods-sold amount measures.
| Measure Name |
|---|
| Amount COGS - Last 365 Days |
| Amount Sold - Last 30 Days |
| Amount Sold - Last 365 Days |
| Amount Sold - Last 60 Days |
Calendar Pattern Measures
Cumulative and comparative inventory quantities and amounts by week, month, quarter, and year.
| Measure Name |
|---|
| Adjustment Amount - Cumulative by Month |
| Adjustment Amount - Cumulative by Quarter |
| Adjustment Amount - Cumulative by Week |
| Adjustment Amount - Cumulative by Year |
| Adjustment Quantity - Cumulative by Month |
| Adjustment Quantity - Cumulative by Quarter |
| Adjustment Quantity - Cumulative by Week |
| Adjustment Quantity - Cumulative by Year |
| COGS Amount - Cumulative by Month |
| COGS Amount - Cumulative by Quarter |
| COGS Amount - Cumulative by Week |
| COGS Amount - Cumulative by Year |
| Completed Builds Amount - Cumulative by Month |
| Completed Builds Amount - Cumulative by Quarter |
| Completed Builds Amount - Cumulative by Week |
| Completed Builds Amount - Cumulative by Year |
| Completed Builds Quantity - Cumulative by Month |
| Completed Builds Quantity - Cumulative by Quarter |
| Completed Builds Quantity - Cumulative by Week |
| Completed Builds Quantity - Cumulative by Year |
| Consumption Amount - Cumulative by Month |
| Consumption Amount - Cumulative by Quarter |
| Consumption Amount - Cumulative by Week |
| Consumption Amount - Cumulative by Year |
| Consumption Quantity - Cumulative by Month |
| Consumption Quantity - Cumulative by Quarter |
| Consumption Quantity - Cumulative by Week |
| Consumption Quantity - Cumulative by Year |
| Customers (New) - Cumulative by Month |
| Customers (New) - Cumulative by Quarter |
| Customers (New) - Cumulative by Year |
| Fulfillment Rate - by Month |
| Fulfillment Rate - by Quarter |
| Fulfillment Rate - by Week |
| Fulfillment Rate - by Year |
| Inventory Activity - Adjustments Quantity |
| Inventory Activity - Completed Builds Quantity |
| Inventory Activity - Purchase Quantity |
| Inventory Activity - Sales Quantity |
| Inventory On Hand Quantity |
| Inventory On Hand Valuation |
| Margin % - Average by Month |
| Margin % - Average by Quarter |
| Margin % - Average by Week |
| Margin % - Average by Year |
| Markup % - Average by Month |
| Markup % - Average by Quarter |
| Markup % - Average by Week |
| Markup % - Average by Year |
| Open Net PO/SO Quantity - Cumulative by Shipping Month |
| Open Net PO/SO Quantity - Cumulative by Shipping Week |
| Open PO Quantity - Cumulative by Shipping Month |
| Open PO Quantity - Cumulative by Shipping Week |
| Open SO Quantity - Cumulative by Shipping Month |
| Open SO Quantity - Cumulative by Shipping Week |
| Pending Builds Quantity - Cumulative by Month |
| Pending Builds Quantity - Cumulative by Quarter |
| Pending Builds Quantity - Cumulative by Week |
| Pending Builds Quantity - Cumulative by Year |
| Purchase Amount - Cumulative by Month |
| Purchase Amount - Cumulative by Quarter |
| Purchase Amount - Cumulative by Week |
| Purchase Amount - Cumulative by Year |
| Purchase Quantity - Cumulative by Month |
| Purchase Quantity - Cumulative by Quarter |
| Purchase Quantity - Cumulative by Week |
| Purchase Quantity - Cumulative by Year |
| Purchasing Rate - Average by Month |
| Purchasing Rate - Average by Quarter |
| Purchasing Rate - Average by Week |
| Purchasing Rate - Average by Year |
| Sales Amount - Cumulative by Month |
| Sales Amount - Cumulative by Quarter |
| Sales Amount - Cumulative by Week |
| Sales Amount - Cumulative by Year |
| Sales Order Initial Invoiced Quantity - Cumulative by Month |
| Sales Order Initial Invoiced Quantity - Cumulative by Quarter |
| Sales Order Initial Invoiced Quantity - Cumulative by Week |
| Sales Order Initial Invoiced Quantity - Cumulative by Year |
| Sales Order Original Quantity - Cumulative by Month |
| Sales Order Original Quantity - Cumulative by Quarter |
| Sales Order Original Quantity - Cumulative by Week |
| Sales Order Original Quantity - Cumulative by Year |
| Sales Profit Margin Amount - Cumulative by Month |
| Sales Profit Margin Amount - Cumulative by Quarter |
| Sales Profit Margin Amount - Cumulative by Week |
| Sales Profit Margin Amount - Cumulative by Year |
| Sales Quantity - Cumulative by Month |
| Sales Quantity - Cumulative by Month PM |
| Sales Quantity - Cumulative by Quarter |
| Sales Quantity - Cumulative by Quarter PQ |
| Sales Quantity - Cumulative by Week |
| Sales Quantity - Cumulative by Year |
| Sales Quantity - Cumulative by Year PY |
| Sales Quantity - MOM % |
| Sales Quantity - QOQ % |
| Sales Quantity - YOY % |
| Transfer Amount - Cumulative by Month |
| Transfer Amount - Cumulative by Quarter |
| Transfer Amount - Cumulative by Week |
| Transfer Amount - Cumulative by Year |
| Transfer Quantity - Cumulative by Month |
| Transfer Quantity - Cumulative by Quarter |
| Transfer Quantity - Cumulative by Week |
| Transfer Quantity - Cumulative by Year |
Customer Measures
Customer purchase behavior, transaction frequency, recency, averages, and lifetime-value measures.
| Measure Name |
|---|
| Customer - Average Sales Amount |
| Customer - Average Sales Quantity |
| Customer - Days Since Last Purchase |
| Customer - First Sales Transaction Amount |
| Customer - First Sales Transaction Date |
| Customer - Last Sales Transaction Amount |
| Customer - Last Sales Transaction Date |
| Customer - Lifetime Value |
| Customer - Sales Transaction Count |
| Customer Count (All) |
| Customer Count (New) |
| Customer Count (New) - Current Month-to-Date |
| Customer Count (New) - Current Quarter-to-Date |
| Customer Count (New) - Current Year-to-Date |
| Customer Count (New) - Current Year-to-Last Month |
| Customer Count (New) - Last Month |
| Customer Count (New) - Last Month-to-Date |
| Customer Count (New) - Last Quarter |
| Customer Count (New) - Last Quarter-to-Date |
| Customer Count (New) - Last Week |
| Customer Count (New) - Previous Year |
| Customer Count (New) - Previous Year Month-to-Date |
| Customer Count (New) - Previous Year Quarter-to-Date |
| Customer Count (New) - Previous Year-to-Date |
Inventory Measures
Inventory availability, fulfillment, turnover, days sales, days out of stock, GMROI, and quantity-on-hand measures.
| Measure Name |
|---|
| Inventory - Days out of Stock |
| Inventory - Days out of Stock (Last 30 Days) |
| Inventory - Days Sales [DSI] |
| Inventory - Fulfillment Rate (Last 30 Days) |
| Inventory - Fulfillment Rate (Last 365 Days) |
| Inventory - Gross Margin on Investment [GMROI] |
| Inventory - Quantity On Hand (Cumulative) |
| Inventory - Quantity On Hand (Today) |
| Inventory - Retail Value |
| Inventory - Turnover Ratio |
| Inventory - Valuation (30 Days Ago) |
| Inventory - Valuation (365 Days Ago) |
| Inventory - Valuation (Today) |
| Inventory to Sales Ratio [I/S] (Last 30 Days) |
| Inventory to Sales Ratio [I/S] (Last 365 Days) |
Item Measures
Item-count measures for all items and assemblies.
| Measure Name |
|---|
| Item Count (All) |
| Item Count (Assemblies) |
Quantity Measures
Current, prior-period, cumulative, and comparative inventory-quantity measures.
| Measure Name |
|---|
| Quantity Completed Builds - Current Month |
| Quantity Completed Builds - Current Month-to-Date |
| Quantity Completed Builds - Current Quarter |
| Quantity Completed Builds - Current Quarter-to-Date |
| Quantity Completed Builds - Current Week |
| Quantity Completed Builds - Current Week-to-Date |
| Quantity Completed Builds - Current Year |
| Quantity Completed Builds - Current Year-to-Date |
| Quantity Completed Builds - Current Year-to-Last Month |
| Quantity Completed Builds - Last Month |
| Quantity Completed Builds - Last Month-to-Date |
| Quantity Completed Builds - Last Quarter |
| Quantity Completed Builds - Last Quarter-to-Date |
| Quantity Completed Builds - Last Week |
| Quantity Completed Builds - Last Week-to-Date |
| Quantity Completed Builds - Previous Year |
| Quantity Completed Builds - Previous Year Last Month |
| Quantity Completed Builds - Previous Year Last Quarter |
| Quantity Completed Builds - Previous Year Month |
| Quantity Completed Builds - Previous Year Month-to-Date |
| Quantity Completed Builds - Previous Year Quarter |
| Quantity Completed Builds - Previous Year Quarter-to-Date |
| Quantity Completed Builds - Previous Year-to-Date |
| Quantity Completed Builds - Previous Year-to-Last Month |
| Quantity Completed Builds - Today |
| Quantity Completed Builds - Tomorrow |
| Quantity Completed Builds - Yesterday |
| Quantity Consumed - Current Month |
| Quantity Consumed - Current Month-to-Date |
| Quantity Consumed - Current Quarter |
| Quantity Consumed - Current Quarter-to-Date |
| Quantity Consumed - Current Week |
| Quantity Consumed - Current Week-to-Date |
| Quantity Consumed - Current Year |
| Quantity Consumed - Current Year-to-Date |
| Quantity Consumed - Current Year-to-Last Month |
| Quantity Consumed - Last 30 Days |
| Quantity Consumed - Last 60 Days |
| Quantity Consumed - Last Month |
| Quantity Consumed - Last Month-to-Date |
| Quantity Consumed - Last Quarter |
| Quantity Consumed - Last Quarter-to-Date |
| Quantity Consumed - Last Week |
| Quantity Consumed - Last Week-to-Date |
| Quantity Consumed - Previous Year |
| Quantity Consumed - Previous Year Last 30 Days |
| Quantity Consumed - Previous Year Last 60 Days |
| Quantity Consumed - Previous Year Last Month |
| Quantity Consumed - Previous Year Last Quarter |
| Quantity Consumed - Previous Year Month |
| Quantity Consumed - Previous Year Month-to-Date |
| Quantity Consumed - Previous Year Quarter |
| Quantity Consumed - Previous Year Quarter-to-Date |
| Quantity Consumed - Previous Year-to-Date |
| Quantity Consumed - Previous Year-to-Last Month |
| Quantity Consumed - Today |
| Quantity Consumed - Tomorrow |
| Quantity Consumed - Yesterday |
| Quantity Open Net PO/SO - Due Current Month |
| Quantity Open Net PO/SO - Due Current Quarter |
| Quantity Open Net PO/SO - Due Current Week |
| Quantity Open Net PO/SO - Due Current Year |
| Quantity Open Net PO/SO - Due Next Month |
| Quantity Open Net PO/SO - Due Next Quarter |
| Quantity Open Net PO/SO - Due Next Two Weeks |
| Quantity Open Net PO/SO - Due Next Week |
| Quantity Open Net PO/SO - Due Next Year |
| Quantity Open Net PO/SO - Due Today |
| Quantity Open Net PO/SO - Due Tomorrow |
| Quantity Open PO - Expected Current Month |
| Quantity Open PO - Expected Current Quarter |
| Quantity Open PO - Expected Current Week |
| Quantity Open PO - Expected Current Year |
| Quantity Open PO - Expected Next Month |
| Quantity Open PO - Expected Next Quarter |
| Quantity Open PO - Expected Next Two Weeks |
| Quantity Open PO - Expected Next Week |
| Quantity Open PO - Expected Next Year |
| Quantity Open PO - Expected Today |
| Quantity Open PO - Expected Tomorrow |
| Quantity Open SO - Shipping Current Month |
| Quantity Open SO - Shipping Current Quarter |
| Quantity Open SO - Shipping Current Week |
| Quantity Open SO - Shipping Current Year |
| Quantity Open SO - Shipping Next Month |
| Quantity Open SO - Shipping Next Quarter |
| Quantity Open SO - Shipping Next Two Weeks |
| Quantity Open SO - Shipping Next Week |
| Quantity Open SO - Shipping Next Year |
| Quantity Open SO - Shipping Today |
| Quantity Open SO - Shipping Tomorrow |
| Quantity Pending Builds - Current Month |
| Quantity Pending Builds - Current Quarter |
| Quantity Pending Builds - Current Week |
| Quantity Pending Builds - Current Year |
| Quantity Pending Builds - Next Month |
| Quantity Pending Builds - Next Quarter |
| Quantity Pending Builds - Next Two Weeks |
| Quantity Pending Builds - Next Week |
| Quantity Pending Builds - Next Year |
| Quantity Pending Builds - Today |
| Quantity Pending Builds - Tomorrow |
| Quantity Sales Order Initial Invoiced - Last 30 Days |
| Quantity Sales Order Initial Invoiced - Last 365 Days |
| Quantity Sales Order Original - Last 30 Days |
| Quantity Sales Order Original - Last 365 Days |
| Quantity Sold - Current Month |
| Quantity Sold - Current Month-to-Date |
| Quantity Sold - Current Quarter |
| Quantity Sold - Current Quarter-to-Date |
| Quantity Sold - Current Week |
| Quantity Sold - Current Week-to-Date |
| Quantity Sold - Current Year |
| Quantity Sold - Current Year-to-Date |
| Quantity Sold - Current Year-to-Last Month |
| Quantity Sold - Last 30 Days |
| Quantity Sold - Last 60 Days |
| Quantity Sold - Last Month |
| Quantity Sold - Last Month-to-Date |
| Quantity Sold - Last Quarter |
| Quantity Sold - Last Quarter-to-Date |
| Quantity Sold - Last Week |
| Quantity Sold - Last Week-to-Date |
| Quantity Sold - Previous Year |
| Quantity Sold - Previous Year Last 30 Days |
| Quantity Sold - Previous Year Last 60 Days |
| Quantity Sold - Previous Year Last Month |
| Quantity Sold - Previous Year Last Quarter |
| Quantity Sold - Previous Year Month |
| Quantity Sold - Previous Year Month-to-Date |
| Quantity Sold - Previous Year Quarter |
| Quantity Sold - Previous Year Quarter-to-Date |
| Quantity Sold - Previous Year-to-Date |
| Quantity Sold - Previous Year-to-Last Month |
| Quantity Sold - Today |
| Quantity Sold - Tomorrow |
| Quantity Sold - Yesterday |
Vendor Measures
Vendor purchase frequency, recency, average value, and last-purchase measures.
| Measure Name |
|---|
| Vendor - Average Purchase Amount |
| Vendor - Average Purchase Quantity |
| Vendor - Days Since Last Purchase |
| Vendor - Last Purchase Transaction Date |
| Vendor - Last Purchase Transaction Quantity |
| Vendor - Purchase Transaction Count |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article