Measure Summary
This reference lists the DAX measures included in the prepared QQube Audit Trail examples for Power BI and Excel Power Pivot. The measures support transaction-change and data-entry analysis.
Data Model Audit Trail | Reference Type DAX measure reference |
Visible Measures 13 | Display Folders 2 |
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 Audit Trail 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 (10 measures)
- Data Entry Measures (3 measures)
.Base Measures
Base calculations from the Audit Trail FACT values. They support custom analysis and the customer-facing data-entry measures.
| Measure Name |
|---|
| .Document Summary Amount Change from Previous |
| .Document Summary Current Amount |
| .Document Summary Original Amount |
| .Line Amount |
| .Line Credit Amount |
| .Line Debit Amount |
| .Line Open Amount |
| .Line Paid Amount |
| .Line Quantity/Hours |
| .Line Rate |
Data Entry Measures
Measures that count new transactions, modified transactions, and both activity types together.
| Measure Name |
|---|
| Document Data Entry - Modified |
| Document Data Entry - New |
| Document Data Entry - New and Modified |
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