DAX Measures – Cash Position Data Model

Modified on Wed, 29 Jul at 3:12 AM

Measure Summary

This reference lists the visible DAX measures included in the prepared QQube Cash Position examples for Power BI and Excel Power Pivot. The measures support open receivables, open payables, cash on hand, aging, terms, combined balances, and running-total analysis.

Data Model

Cash Position

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.

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 according to their placement in Power BI and Excel Power Pivot.

.Base Measures (11 measures)
Cash Position Measures (4 measures)

.Base Measures

Base calculations for open Accounts Payable, open Accounts Receivable, applied amounts, cash on hand, original amounts, and quantities.

Measure Name
.Line A/P Open Amount
.Line A/P Open Amount (Foreign)
.Line A/R Open Amount
.Line A/R Open Amount (Foreign)
.Line ARAP Applied Amount
.Line ARAP Applied Amount (Foreign)
.Line Cash On Hand Amount
.Line Original Amount
.Line Original Amount (Foreign)
.Line Quantity
.Line Quantity Printed

Back to Measure Folders

Cash Position Measures

Cash-position calculations for aging, payment terms, combined amounts, and running totals.

Measure Name
Average Days Aged Past Due Date
Average Days For Terms
Combined Line Amount
Running Total

Back to Measure Folders