Measure Summary
This reference lists the DAX measures included in the prepared QQube General Ledger Detail examples for Power BI and Excel Power Pivot. The measures support actual, budget, forecast, debit, credit, paid, foreign-currency, quantity, rate, current-period, previous-year, and daily analysis.
Data Model General Ledger Detail | Reference Type DAX measure reference |
Visible Measures 131 | Display Folders 7 |
Measure Names Names are shown exactly as they appear in the model. Hidden measures are not included. | |
Three measures are not assigned to a display folder.
They provide Power BI company-filter support for the Account, Job, and Source Name slicers.
Power BI company filtering
These support measures keep the Account, Job, and Source Name slicers aligned with the selected company. Excel Power Pivot handles company 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 (3 measures)
- .Base Measures (16 measures)
- .Base Measures For Hierarchies (16 measures)
- Calendar Pattern Measures (24 measures)
- Current Measures (18 measures)
- Previous Year Measures (36 measures)
- Today Measures (9 measures)
- Yesterday Measures (9 measures)
Measures Without a Display Folder
These visible measures support company-aware Account, Job, and Source Name slicers in Power BI.
| Measure Name |
|---|
| Account Slicer: Company Filter |
| Job Slicer: Company Filter |
| Source Name Slicer: Company Filter |
.Base Measures
Base calculations for General Ledger amounts, budget and forecast values, credits, debits, open and paid amounts, foreign values, quantities, rates, and exchange rates.
| Measure Name |
|---|
| .Line Amount |
| .Line Amount (Foreign)] |
| .Line Budget Amount] |
| .Line Budget Credit Amount |
| .Line Budget Debit Amount |
| .Line Credit Amount |
| .Line Debit Amount |
| .Line Exchange Rate |
| .Line Forecast Amount |
| .Line Forecast Credit Amount |
| .Line Forecast Debit Amount |
| .Line Open Amount |
| .Line Paid Amount |
| .Line Quantity |
| .Line Rate |
| .Line Rate Percent |
.Base Measures For Hierarchies
Base calculations used with hierarchy-aware General Ledger reporting.
| Measure Name |
|---|
| .Hierarchy Line Amount |
| .Hierarchy Line Amount (Foreign) |
| .Hierarchy Line Budget Amount |
| .Hierarchy Line Budget Credit Amount |
| .Hierarchy Line Budget Debit Amount |
| .Hierarchy Line Credit Amount |
| .Hierarchy Line Debit Amount |
| .Hierarchy Line Exchange Rate |
| .Hierarchy Line Forecast Amount |
| .Hierarchy Line Forecast Credit Amount |
| .Hierarchy Line Forecast Debit Amount |
| .Hierarchy Line Open Amount |
| .Hierarchy Line Paid Amount |
| .Hierarchy Line Quantity |
| .Hierarchy Line Rate |
| .Hierarchy Line Rate Percent |
Calendar Pattern Measures
General Ledger actual, budget, forecast, paid, debit, credit, foreign, and exchange-rate values summarized by month, quarter, and year.
| Measure Name |
|---|
| General Ledger by Month Actual |
| General Ledger by Month Actual Credit |
| General Ledger by Month Actual Debit |
| General Ledger by Month Actual Paid |
| General Ledger by Month Budget |
| General Ledger by Month Exchange Rate |
| General Ledger by Month Forecast |
| General Ledger by Month Foreign |
| General Ledger by Quarter Actual |
| General Ledger by Quarter Actual Credit |
| General Ledger by Quarter Actual Debit |
| General Ledger by Quarter Actual Paid |
| General Ledger by Quarter Budget |
| General Ledger by Quarter Exchange Rate |
| General Ledger by Quarter Forecast |
| General Ledger by Quarter Foreign |
| General Ledger by Year Actual |
| General Ledger by Year Actual Credit |
| General Ledger by Year Actual Debit |
| General Ledger by Year Actual Paid |
| General Ledger by Year Budget |
| General Ledger by Year Exchange Rate |
| General Ledger by Year Forecast |
| General Ledger by Year Foreign |
Current Measures
Current month-to-date and current year-to-date General Ledger values.
| Measure Name |
|---|
| Current Month-to-Date Actual |
| Current Month-to-Date Actual Credit |
| Current Month-to-Date Actual Debit |
| Current Month-to-Date Actual Paid |
| Current Month-to-Date Budget |
| Current Month-to-Date Exchange Rate |
| Current Month-to-Date Forecast |
| Current Month-to-Date Foreign |
| Current Month-to-Date Quantity |
| Current Year-to-Date Actual |
| Current Year-to-Date Actual Credit |
| Current Year-to-Date Actual Debit |
| Current Year-to-Date Amount Paid |
| Current Year-to-Date Budget |
| Current Year-to-Date Exchange Rate |
| Current Year-to-Date Forecast |
| Current Year-to-Date Foreign |
| Current Year-to-Date Quantity |
Previous Year Measures
Previous-year, previous-year last-month, month-to-date, and year-to-date General Ledger values.
| Measure Name |
|---|
| Previous Year Actual |
| Previous Year Actual Credit |
| Previous Year Actual Debit |
| Previous Year Actual Paid |
| Previous Year Budget |
| Previous Year Exchange Rate |
| Previous Year Forecast |
| Previous Year Foreign |
| Previous Year Last Month Actual |
| Previous Year Last Month Actual Credit |
| Previous Year Last Month Actual Debit |
| Previous Year Last Month Actual Paid |
| Previous Year Last Month Budget |
| Previous Year Last Month Exchange Rate |
| Previous Year Last Month Forecast |
| Previous Year Last Month Foreign |
| Previous Year Last Month Quantity |
| Previous Year Month-to-Date Actual |
| Previous Year Month-to-Date Actual Credit |
| Previous Year Month-to-Date Actual Debit |
| Previous Year Month-to-Date Actual Paid |
| Previous Year Month-to-Date Budget |
| Previous Year Month-to-Date Exchange Rate |
| Previous Year Month-to-Date Forecast |
| Previous Year Month-to-Date Foreign |
| Previous Year Month-to-Date Quantity |
| Previous Year Quantity |
| Previous Year-to-Date Actual |
| Previous Year-to-Date Actual Credit |
| Previous Year-to-Date Actual Debit |
| Previous Year-to-Date Actual Paid |
| Previous Year-to-Date Budget |
| Previous Year-to-Date Exchange Rate |
| Previous Year-to-Date Forecast |
| Previous Year-to-Date Foreign |
| Previous Year-to-Date Quantity |
Today Measures
General Ledger values for today.
| Measure Name |
|---|
| Today Actual |
| Today Actual Credit |
| Today Actual Debit |
| Today Actual Paid |
| Today Budget |
| Today Exchange Rate |
| Today Forecast |
| Today Foreign |
| Today Quantity |
Yesterday Measures
General Ledger values for yesterday.
| Measure Name |
|---|
| Yesterday Actual |
| Yesterday Actual Credit |
| Yesterday Actual Debit |
| Yesterday Actual Paid |
| Yesterday Budget |
| Yesterday Exchange Rate |
| Yesterday Forecast |
| Yesterday Foreign |
| Yesterday Quantity |
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