DAX Measures – Purchases Data Model

Modified on Wed, 29 Jul at 1:00 AM

Measure Summary

This reference lists the DAX measures included in the prepared QQube Purchases examples for Power BI and Excel Power Pivot. The measures support purchasing amounts, quantities, open Purchase Orders, discounts, vendor activity, and period comparisons.

Data Model

Purchases

Reference Type

DAX measure reference

Visible Measures

180

Display Folders

Measure Names

Names are shown exactly as they appear in the model. Hidden measures are not included.

Five measures are not assigned to a display folder.

Two are purchase-discount measures. The other three support the Item, Job, and Vendor bridge tables used in Power BI so each slicer shows only values associated with the selected company. Excel Power Pivot handles this filtering automatically.

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 (5 measures)
.Base Measures (28 measures)
Calendar Pattern Measures (36 measures)
Open PO Measures (11 measures)
Purchasing Amount Measures (47 measures)
Purchasing Quantity Measures (47 measures)
Vendor Measures (6 measures)

Measures Without a Display Folder

Two purchase-discount measures and three Power BI company-filter measures for the Item, Job, and Vendor slicers.

Measure Name
Discount Amount Actual
Discount Amount Suggested
Item Slicer: Company Filter
Job Slicer: Company Filter
Vendor Slicer: Company Filter

Back to Measure Sections

.Base Measures

Base calculations for purchase quantities, rates, amounts, open Purchase Orders, received values, exchange rates, tax rates, and related purchasing values.

Measure Name
.Line Additional Calculated COGS Amount
.Line Additional Calculated COGS Amount (Foreign)
.Line Exchange Rate
.Line PO Open Amount
.Line PO Open Amount (CAN)
.Line PO Open Amount (Foreign)
.Line PO Open Quantity
.Line PO Open Quantity [Printed]
.Line PO Original Amount
.Line PO Original Amount (CAN)
.Line PO Original Amount (Foreign)
.Line PO Original Quantity
.Line PO Original Quantity [Printed]
.Line PO Received Amount
.Line PO Received Amount (CAN)
.Line PO Received Amount (Foreign)
.Line PO Received Quantity
.Line PO Received Quantity [Printed]
.Line Purchasing Amount
.Line Purchasing Amount (Foreign)
.Line Purchasing Open Amount
.Line Purchasing Paid Amount
.Line Quantity
.Line Quantity [Printed]
.Line Rate
.Line Rate (Foreign)
.Line Rate [Printed]
.Line Tax Rate (CAN)

Back to Measure Sections

Calendar Pattern Measures

Cumulative and average Purchase Order and purchasing measures by week, month, quarter, or year.

Measure Name
PO Open Amount (CAN) - Cumulative by Expected Month
PO Open Amount (CAN) - Cumulative by Expected Week
PO Open Amount (Foreign) - Cumulative by Expected Month
PO Open Amount (Foreign) - Cumulative by Expected Week
PO Open Amount - Cumulative by Expected Month
PO Open Amount - Cumulative by Expected Week
PO Open Quantity - Cumulative by Expected Month
PO Open Quantity - Cumulative by Expected Week
PO Open Quantity [Printed] - Cumulative by Expected Month
PO Open Quantity [Printed] - Cumulative by Expected Week
Purchasing Additional Calculated COGS Amount - Cumulative by Month
Purchasing Additional Calculated COGS Amount - Cumulative by Week
Purchasing Additional Calculated COGS Amount - Cumulative by Year
Purchasing Amount (Foreign) - Cumulative by Month
Purchasing Amount (Foreign) - Cumulative by Quarter
Purchasing Amount (Foreign) - Cumulative by Week
Purchasing Amount (Foreign) - Cumulative by Year
Purchasing Amount - Cumulative by Month
Purchasing Amount - Cumulative by Quarter
Purchasing Amount - Cumulative by Week
Purchasing Amount - Cumulative by Year
Purchasing Exchange Rate by Month
Purchasing Exchange Rate by Quarter
Purchasing Exchange Rate by Week
Purchasing Exchange Rate by Year
Purchasing Open Amount [Current] - Cumulative by Month
Purchasing Open Amount [Current] - Cumulative by Week
Purchasing Open Amount [Current] - Cumulative by Year
Purchasing Quantity - Cumulative by Month
Purchasing Quantity - Cumulative by Quarter
Purchasing Quantity - Cumulative by Week
Purchasing Quantity - Cumulative by Year
Purchasing Rate - Average by Month
Purchasing Rate - Average by Quarter
Purchasing Rate - Average by Week
Purchasing Rate - Average by Year

Back to Measure Sections

Open PO Measures

Open Purchase Order quantities for current and upcoming expected-date periods.

Measure Name
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

Back to Measure Sections

Purchasing Amount Measures

Current, prior-period, and comparative purchasing-amount measures.

Measure Name
Amount Purchased - Compare Current Month vs Previous Year Month
Amount Purchased - Compare Current Month vs Previous Year Month %
Amount Purchased - Compare Current MTD vs Previous Year MTD
Amount Purchased - Compare Current MTD vs. Previous Year MTD %
Amount Purchased - Compare Current QTD vs Last QTD
Amount Purchased - Compare Current QTD vs Last QTD %
Amount Purchased - Compare Current QTD vs Previous Year QTD
Amount Purchased - Compare Current QTD vs Previous Year QTD %
Amount Purchased - Compare Current Quarter vs Previous Year Quarter
Amount Purchased - Compare Current Quarter vs Previous Year Quarter %
Amount Purchased - Compare Current WTD vs Last WTD
Amount Purchased - Compare Current WTD vs Last WTD %
Amount Purchased - Compare Current Year-to-Last Month vs Previous Year-to-Last Month
Amount Purchased - Compare Current Year-to-Last Month vs Previous Year-to-Last Month %
Amount Purchased - Compare Current YTD vs Previous YTD
Amount Purchased - Compare Current YTD vs Previous YTD %
Amount Purchased - Compare Last Month vs Previous Year Last Month
Amount Purchased - Compare Last Month vs Previous Year Last Month %
Amount Purchased - Compare Last Quarter vs Previous Year Last Quarter
Amount Purchased - Compare Last Quarter vs Previous Year Last Quarter %
Amount Purchased - Current Month
Amount Purchased - Current Month-to-Date
Amount Purchased - Current Quarter
Amount Purchased - Current Quarter-to-Date
Amount Purchased - Current Week
Amount Purchased - Current Week-to-Date
Amount Purchased - Current Year
Amount Purchased - Current Year-to-Date
Amount Purchased - Current Year-to-Last Month
Amount Purchased - Last Month
Amount Purchased - Last Month-to-Date
Amount Purchased - Last Quarter
Amount Purchased - Last Quarter-to-Date
Amount Purchased - Last Week
Amount Purchased - Last Week-to-Date
Amount Purchased - Previous Year
Amount Purchased - Previous Year Last Month
Amount Purchased - Previous Year Last Quarter
Amount Purchased - Previous Year Month
Amount Purchased - Previous Year Month-to-Date
Amount Purchased - Previous Year Quarter
Amount Purchased - Previous Year Quarter-to-Date
Amount Purchased - Previous Year-to-Date
Amount Purchased - Previous Year-to-Last Month
Amount Purchased - Today
Amount Purchased - Tomorrow
Amount Purchased - Yesterday

Back to Measure Sections

Purchasing Quantity Measures

Current, prior-period, and comparative purchasing-quantity measures.

Measure Name
Quantity Purchased - Compare Current Month vs Previous Year Month
Quantity Purchased - Compare Current Month vs Previous Year Month %
Quantity Purchased - Compare Current MTD vs Previous Year MTD
Quantity Purchased - Compare Current MTD vs. Previous Year MTD %
Quantity Purchased - Compare Current QTD vs Last QTD
Quantity Purchased - Compare Current QTD vs Last QTD %
Quantity Purchased - Compare Current QTD vs Previous Year QTD
Quantity Purchased - Compare Current QTD vs Previous Year QTD %
Quantity Purchased - Compare Current Quarter vs Previous Year Quarter
Quantity Purchased - Compare Current Quarter vs Previous Year Quarter %
Quantity Purchased - Compare Current WTD vs Last WTD
Quantity Purchased - Compare Current WTD vs Last WTD %
Quantity Purchased - Compare Current Year-to-Last Month vs Previous Year-to-Last Month
Quantity Purchased - Compare Current Year-to-Last Month vs Previous Year-to-Last Month %
Quantity Purchased - Compare Current YTD vs Previous YTD
Quantity Purchased - Compare Current YTD vs Previous YTD %
Quantity Purchased - Compare Last Month vs Previous Year Last Month
Quantity Purchased - Compare Last Month vs Previous Year Last Month %
Quantity Purchased - Compare Last Quarter vs Previous Year Last Quarter
Quantity Purchased - Compare Last Quarter vs Previous Year Last Quarter %
Quantity Purchased - Current Month
Quantity Purchased - Current Month-to-Date
Quantity Purchased - Current Quarter
Quantity Purchased - Current Quarter-to-Date
Quantity Purchased - Current Week
Quantity Purchased - Current Week-to-Date
Quantity Purchased - Current Year
Quantity Purchased - Current Year-to-Date
Quantity Purchased - Current Year-to-Last Month
Quantity Purchased - Last Month
Quantity Purchased - Last Month-to-Date
Quantity Purchased - Last Quarter
Quantity Purchased - Last Quarter-to-Date
Quantity Purchased - Last Week
Quantity Purchased - Last Week-to-Date
Quantity Purchased - Previous Year
Quantity Purchased - Previous Year Last Month
Quantity Purchased - Previous Year Last Quarter
Quantity Purchased - Previous Year Month
Quantity Purchased - Previous Year Month-to-Date
Quantity Purchased - Previous Year Quarter
Quantity Purchased - Previous Year Quarter-to-Date
Quantity Purchased - Previous Year-to-Date
Quantity Purchased - Previous Year-to-Last Month
Quantity Purchased - Today
Quantity Purchased - Tomorrow
Quantity Purchased - Yesterday

Back to Measure Sections

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 Amount
Vendor - Last Purchase Transaction Date
Vendor - Purchase Transaction Count

Back to Measure Sections