DAX Measures – Accounts Payable Data Model

Modified on Wed, 29 Jul at 1:27 AM

Measure Summary

This reference lists the DAX measures included in the prepared QQube Accounts Payable examples for Power BI and Excel Power Pivot. The measures support open balances, applied amounts, aging, payment terms, and cumulative payable analysis.

Data Model

Accounts Payable

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.

Power BI company-filter measures

The five measures without a display folder support the Account, Class, Job, Split Account Offset, and Vendor bridge tables used in Power BI. They limit each slicer to 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 (22 measures)
Average Days Measures (2 measures)
Calendar Pattern Measures (4 measures)

Measures Without a Display Folder

Power BI support measures for the Account, Class, Job, Split Account Offset, and Vendor bridge tables.

Measure Name
Account Slicer: Company Filter
Class Slicer: Company Filter
Job Slicer: Company Filter
Split Account Offset Slicer: Company Filter
Vendor Slicer: Company Filter

Back to Measure Sections

.Base Measures

Base calculations for original, applied, open, and aging Accounts Payable amounts, rates, quantities, exchange rates, and aging buckets.

Measure Name
.Due Date Aging Bucket1
.Due Date Aging Bucket2
.Due Date Aging Bucket3
.Due Date Aging Bucket4
.Due Date Aging Current
.Line Applied To A/P Amount
.Line Applied To A/P Amount (Foreign)
.Line Exchange Rate
.Line Open A/P Amount
.Line Open A/P Amount (Foreign)
.Line Original Amount
.Line Original Amount (Foreign)
.Line Quantity
.Line Quantity [Printed]
.Line Rate
.Line Rate [Printed]
.Line Rate Percent
.Txn Date Aging Bucket1
.Txn Date Aging Bucket2
.Txn Date Aging Bucket3
.Txn Date Aging Bucket4
.Txn Date Aging Current

Back to Measure Sections

Average Days Measures

Measures for average payment terms and average days aged past the due date.

Measure Name
Average Days Aged Past Due Date
Average Days For Terms

Back to Measure Sections

Calendar Pattern Measures

Cumulative original and outstanding Accounts Payable amounts by week and month.

Measure Name
AP Amount Due - Cumuilative by Week
AP Amount Due - Cumulative by Month
AP Amount Original - Cumuilative by Week
AP Amount Original - Cumulative by Month

Back to Measure Sections