DAX Measures – Open Purchase Orders Data Model

Modified on Wed, 29 Jul at 1:17 AM

Measure Summary

This reference lists the DAX measures included in the prepared QQube Open Purchase Orders examples for Power BI and Excel Power Pivot. The measures support original, received, and open quantities and amounts by expected period.

Data Model

Open Purchase Orders

Reference Type

DAX measure reference

Visible Measures

Display Folders

Measure Names

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

Base-measure visibility varies by data model.

The .Base Measures folder is visible in the current Open Purchase Orders 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 Folders

The measures are grouped below by the same display folders used in Power BI and Excel Power Pivot.

.Base Measures (20 measures)
Calendar Pattern Measures (10 measures)
Open PO Quantity Measures (11 measures)

.Base Measures

Base calculations for original, received, and open Purchase Order quantities, rates, amounts, exchange rates, and Canadian tax values.

Measure Name
.Line Exchange Rate
.Line Open Amount
.Line Open Amount (CAN)
.Line Open Amount (Foreign)
.Line Open Quantity
.Line Open Quantity [Printed]
.Line Original Amount
.Line Original Amount (CAN)
.Line Original Amount (Foreign)
.Line Original Quantity
.Line Original Quantity [Printed]
.Line Rate
.Line Rate (Foreign)
.Line Rate [Printed]
.Line Received Amount
.Line Received Amount (CAN)
.Line Received Amount (Foreign)
.Line Received Quantity
.Line Received Quantity [Printed]
.Line Tax Rate (CAN)

Back to Measure Folders

Calendar Pattern Measures

Cumulative open Purchase Order quantities and amounts by expected week and month.

Measure Name
Open PO Amount (CAN) - Cumulative by Expected Month
Open PO Amount (CAN) - Cumulative by Expected Week
Open PO Amount (Foreign) - Cumulative by Expected Month
Open PO Amount (Foreign) - Cumulative by Expected Week
Open PO Amount - Cumulative by Expected Month
Open PO Amount - Cumulative by Expected Week
Open PO Quantity - Cumulative by Expected Month
Open PO Quantity - Cumulative by Expected Week
Open PO Quantity [Printed] - Cumulative by Expected Month
Open PO Quantity [Printed] - Cumulative by Expected Week

Back to Measure Folders

Open PO Quantity Measures

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

Measure Name
Quantity Open - Expected Current Month
Quantity Open - Expected Current Quarter
Quantity Open - Expected Current Week
Quantity Open - Expected Current Year
Quantity Open - Expected Next Month
Quantity Open - Expected Next Quarter
Quantity Open - Expected Next Two Weeks
Quantity Open - Expected Next Week
Quantity Open - Expected Next Year
Quantity Open - Expected Today
Quantity Open - Expected Tomorrow

Back to Measure Folders