Measure Summary
This reference lists the DAX measures included in the prepared QQube Payroll examples for Power BI and Excel Power Pivot. The measures support wages, payroll hours, commissions, non-wage items, payroll liabilities, rates, and period comparisons.
Data Model Payroll | Reference Type DAX measure reference |
Visible Measures 275 | Display Folders 9 |
Measure Names Names are shown exactly as they appear in the model. Hidden measures are not included. | |
4 Power BI company-filter measures are not assigned to a display folder.
These measures restrict Account, Employee, Job, and Vendor slicers 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 (4 measures)
- .Base Measures (30 measures)
- Calendar Pattern Measures (124 measures)
- Commissions/Piece Work Measures (5 measures)
- Item (Any) Amount Measures (5 measures)
- Liability Measures (18 measures)
- Non-Wage Measures (9 measures)
- Other Payroll Item Qty Measures (8 measures)
- Payroll Hours Qty Measures (8 measures)
- Wage Amount Measures (64 measures)
Measures Without a Display Folder
These Power BI support measures restrict Account, Employee, Job, and Vendor slicers to values associated with the selected company. Excel Power Pivot handles this filtering automatically.
| Measure Name |
|---|
| Account Slicer: Company Filter |
| Employee Slicer: Company Filter |
| Job Slicer: Company Filter |
| Vendor Slicer: Company Filter |
.Base Measures
Base calculations for payroll amounts, quantities, rates, wages, non-wage items, liabilities, and document totals.
| Measure Name |
|---|
| .Document Total Amount |
| .Line Adjustment Non-Posting Amount |
| .Line Adjustment Posting Amount |
| .Line Amount |
| .Line Commissions or Piece Work Quantity |
| .Line Income Subject To Tax |
| .Line Liability Accrued Amount |
| .Line Liability Paid Amount |
| .Line Non-Wage Addition Amount |
| .Line Non-Wage Amount |
| .Line Non-Wage Contribution Amount |
| .Line Non-Wage Deduction Amount |
| .Line Non-Wage Direct Deposit Amount |
| .Line Non-Wage Tax Amount |
| .Line Other Payroll Item Quantity |
| .Line Payroll Hours Quantity |
| .Line Rate |
| .Line Rate Percent |
| .Line Wage Amount |
| .Line Wage Base Amount |
| .Line Wage Base Tips Amount |
| .Line Wage Bonus Amount |
| .Line Wage Commission Amount |
| .Line Wage Hourly Overtime Amount |
| .Line Wage Hourly Regular Amount |
| .Line Wage Hourly Sick Amount |
| .Line Wage Hourly Vacation Amount |
| .Line Wage Salary Regular Amount |
| .Line Wage Salary Sick Amount |
| .Line Wage Salary Vacation Amount |
Calendar Pattern Measures
Cumulative payroll amounts, quantities, rates, and liability comparisons by week, month, quarter, and year.
| Measure Name |
|---|
| Adjustment [Non-Posting] Amount - Cumulative by Week |
| Adjustment [Posting] Amount - Cumulative by Week |
| Adjustment Non-Posting Amount - Cumulative by Month |
| Adjustment Non-Posting Amount - Cumulative by Quarter |
| Adjustment Non-Posting Amount - Cumulative by Year |
| Adjustment Posting Amount - Cumulative by Month |
| Adjustment Posting Amount - Cumulative by Quarter |
| Adjustment Posting Amount - Cumulative by Year |
| Amount - Cumulative by Quarter |
| Amount - Cumulative by Year |
| Amount [Any Item] - Cumulative by Month |
| Amount [Any Item] - Cumulative by Week |
| Commissions or Piece Work [Qty] - Cumulative by Month |
| Commissions or Piece Work [Qty] - Cumulative by Quarter |
| Commissions or Piece Work [Qty] - Cumulative by Week |
| Commissions or Piece Work [Qty] - Cumulative by Year |
| Compare Liabilities Paid vs Accrued - Cumulative by Month |
| Compare Liabilities Paid vs Accrued - Cumulative by Quarter |
| Compare Liabilities Paid vs Accrued - Cumulative by Week |
| Compare Liabilities Paid vs Accrued - Cumulative by Year |
| Document Total Amount - Cumulative by Month |
| Document Total Amount - Cumulative by Quarter |
| Document Total Amount - Cumulative by Week |
| Document Total Amount - Cumulative by Year |
| Income Subject To Tax - Cumulative by Month |
| Income Subject To Tax - Cumulative by Quarter |
| Income Subject To Tax - Cumulative by Week |
| Income Subject To Tax - Cumulative by Year |
| Liability Accrued Amount - Cumulative by Month |
| Liability Accrued Amount - Cumulative by Quarter |
| Liability Accrued Amount - Cumulative by Week |
| Liability Accrued Amount - Cumulative by Year |
| Liability Paid Amount - Cumulative by Month |
| Liability Paid Amount - Cumulative by Quarter |
| Liability Paid Amount - Cumulative by Week |
| Liability Paid Amount - Cumulative by Year |
| Non-Wage Addition Amount - Cumulative by Month |
| Non-Wage Addition Amount - Cumulative by Quarter |
| Non-Wage Addition Amount - Cumulative by Week |
| Non-Wage Addition Amount - Cumulative by Year |
| Non-Wage Amount - Cumulative by Month |
| Non-Wage Amount - Cumulative by Quarter |
| Non-Wage Amount - Cumulative by Week |
| Non-Wage Amount - Cumulative by Year |
| Non-Wage Contribution Amount - Cumulative by Month |
| Non-Wage Contribution Amount - Cumulative by Quarter |
| Non-Wage Contribution Amount - Cumulative by Week |
| Non-Wage Contribution Amount - Cumulative by Year |
| Non-Wage Deduction Amount - Cumulative by Month |
| Non-Wage Deduction Amount - Cumulative by Quarter |
| Non-Wage Deduction Amount - Cumulative by Week |
| Non-Wage Deduction Amount - Cumulative by Year |
| Non-Wage Direct Deposit Amount - Cumulative by Month |
| Non-Wage Direct Deposit Amount - Cumulative by Quarter |
| Non-Wage Direct Deposit Amount - Cumulative by Week |
| Non-Wage Direct Deposit Amount - Cumulative by Year |
| Non-Wage Tax Amount - Cumulative by Month |
| Non-Wage Tax Amount - Cumulative by Quarter |
| Non-Wage Tax Amount - Cumulative by Week |
| Non-Wage Tax Amount - Cumulative by Year |
| Other Payroll Item [Qty] - Cumulative by Month |
| Other Payroll Item [Qty] - Cumulative by Quarter |
| Other Payroll Item [Qty] - Cumulative by Week |
| Other Payroll Item [Qty] - Cumulative by Year |
| Payroll Hours [Qty] - Cumulative by Month |
| Payroll Hours [Qty] - Cumulative by Quarter |
| Payroll Hours [Qty] - Cumulative by Week |
| Payroll Hours [Qty] - Cumulative by Year |
| Rate - Cumulative Average by Month |
| Rate - Cumulative Average by Quarter |
| Rate - Cumulative Average by Week |
| Rate - Cumulative Average by Year |
| Rate Percent [%] - Cumulative Average by Month |
| Rate Percent [%] - Cumulative Average by Quarter |
| Rate Percent [%] - Cumulative Average by Week |
| Rate Percent [%] - Cumulative Average by Year |
| Wage Amount - Cumulative by Month |
| Wage Amount - Cumulative by Quarter |
| Wage Amount - Cumulative by Week |
| Wage Amount - Cumulative by Year |
| Wage Base Amount - Cumulative by Month |
| Wage Base Amount - Cumulative by Quarter |
| Wage Base Amount - Cumulative by Week |
| Wage Base Amount - Cumulative by Year |
| Wage Base Tips Amount - Cumulative by Month |
| Wage Base Tips Amount - Cumulative by Quarter |
| Wage Base Tips Amount - Cumulative by Week |
| Wage Base Tips Amount - Cumulative by Year |
| Wage Bonus Amount - Cumulative by Month |
| Wage Bonus Amount - Cumulative by Quarter |
| Wage Bonus Amount - Cumulative by Week |
| Wage Bonus Amount - Cumulative by Year |
| Wage Commission Amount - Cumulative by Month |
| Wage Commission Amount - Cumulative by Quarter |
| Wage Commission Amount - Cumulative by Week |
| Wage Commission Amount - Cumulative by Year |
| Wage Hourly Overtime Amount - Cumulative by Month |
| Wage Hourly Overtime Amount - Cumulative by Quarter |
| Wage Hourly Overtime Amount - Cumulative by Week |
| Wage Hourly Overtime Amount - Cumulative by Year |
| Wage Hourly Regular Amount - Cumulative by Month |
| Wage Hourly Regular Amount - Cumulative by Quarter |
| Wage Hourly Regular Amount - Cumulative by Week |
| Wage Hourly Regular Amount - Cumulative by Year |
| Wage Hourly Sick Amount - Cumulative by Month |
| Wage Hourly Sick Amount - Cumulative by Quarter |
| Wage Hourly Sick Amount - Cumulative by Week |
| Wage Hourly Sick Amount - Cumulative by Year |
| Wage Hourly Vacation Amount - Cumulative by Month |
| Wage Hourly Vacation Amount - Cumulative by Quarter |
| Wage Hourly Vacation Amount - Cumulative by Week |
| Wage Hourly Vacation Amount - Cumulative by Year |
| Wage Salary Regular Amount - Cumulative by Month |
| Wage Salary Regular Amount - Cumulative by Quarter |
| Wage Salary Regular Amount - Cumulative by Week |
| Wage Salary Regular Amount - Cumulative by Year |
| Wage Salary Sick Amount - Cumulative by Month |
| Wage Salary Sick Amount - Cumulative by Quarter |
| Wage Salary Sick Amount - Cumulative by Week |
| Wage Salary Sick Amount - Cumulative by Year |
| Wage Salary Vacation Amount - Cumulative by Month |
| Wage Salary Vacation Amount - Cumulative by Quarter |
| Wage Salary Vacation Amount - Cumulative by Week |
| Wage Salary Vacation Amount - Cumulative by Year |
Commissions/Piece Work Measures
Current and prior-period commission or piece-work quantity measures.
| Measure Name |
|---|
| Commissions or Piece Work [Qty] - Current Month-to-Date |
| Commissions or Piece Work [Qty] - Current Quarter-to-Date |
| Commissions or Piece Work [Qty] - Current Year-to-Date |
| Commissions or Piece Work [Qty] - Last Week |
| Commissions or Piece Work [Qty] - Previous Year-to-Date |
Item (Any) Amount Measures
Current and prior-period amount measures for payroll items of any type.
| Measure Name |
|---|
| Amount [Any Item] - Current Month-to-Date |
| Amount [Any Item] - Current Quarter-to-Date |
| Amount [Any Item] - Current Year-to-Date |
| Amount [Any Item] - Last Week |
| Amount [Any Item] - Previous Year-to-Date |
Liability Measures
Current-period accrued and paid payroll liabilities, with direct comparison measures.
| Measure Name |
|---|
| Liability Accrued Amount - Current Month-to-Date |
| Liability Accrued Amount - Current Quarter-to-Date |
| Liability Accrued Amount - Current Year-to-Date |
| Liability Accrued Amount - Last Month |
| Liability Accrued Amount - Last Quarter |
| Liability Accrued Amount - Last Week |
| Liability Paid Amount - Current Month-to-Date |
| Liability Paid Amount - Current Quarter-to-Date |
| Liability Paid Amount - Current Year-to-Date |
| Liability Paid Amount - Last Month |
| Liability Paid Amount - Last Quarter |
| Liability Paid Amount - Last Week |
| Liability Paid vs Accrued - Compare Current MTD |
| Liability Paid vs Accrued - Compare Current QTD |
| Liability Paid vs Accrued - Compare Current YTD |
| Liability Paid vs Accrued - Compare Last Month |
| Liability Paid vs Accrued - Compare Last Quarter |
| Liability Paid vs Accrued - Compare Last Week |
Non-Wage Measures
Current and prior-period non-wage additions, contributions, deductions, direct deposits, and tax amounts.
| Measure Name |
|---|
| Non-Wage Addition Amount - Current Year-to-Date |
| Non-Wage Addition Amount - Previous Year-to-Date |
| Non-Wage Amount - Current Year-to-Date |
| Non-Wage Amount - Previous Year-to-Date |
| Non-Wage Contribution Amount - Current Year-to-Date |
| Non-Wage Contribution Amount - Previous Year-to-Date |
| Non-Wage Deduction Amount - Current Year-to-Date |
| Non-Wage Direct Deposit Amount - Current Year-to-Date |
| Non-Wage Tax Amount - Current Year-to-Date |
Other Payroll Item Qty Measures
Current and prior-period quantities for other payroll items.
| Measure Name |
|---|
| Other Payroll Item [Qty] - Current Month-to-Date |
| Other Payroll Item [Qty] - Current Quarter-to-Date |
| Other Payroll Item [Qty] - Current Year-to-Date |
| Other Payroll Item [Qty] - Last Month-to-Date |
| Other Payroll Item [Qty] - Last Week |
| Other Payroll Item [Qty] - Previous Year Month-to-Date |
| Other Payroll Item [Qty] - Previous Year Quarter-to-Date |
| Other Payroll Item [Qty] - Previous Year-to-Date |
Payroll Hours Qty Measures
Current and prior-period payroll-hour quantities.
| Measure Name |
|---|
| Payroll Hours [Qty] - Current Month-to-Date |
| Payroll Hours [Qty] - Current Quarter-to-Date |
| Payroll Hours [Qty] - Current Year-to-Date |
| Payroll Hours [Qty] - Last Month-to-Date |
| Payroll Hours [Qty] - Last Week |
| Payroll Hours [Qty] - Previous Year Month-to-Date |
| Payroll Hours [Qty] - Previous Year Quarter-to-Date |
| Payroll Hours [Qty] - Previous Year-to-Date |
Wage Amount Measures
Current and prior-period wage, tax-base, bonus, commission, hourly, sick, vacation, overtime, and salary amounts.
| Measure Name |
|---|
| Income Subject to Tax - Current Year-to-Date |
| Wage Amount - Current Year-to-Date |
| Wage Amount - Previous Year-to-Date |
| Wage Base Amount - Current Year-to-Date |
| Wage Base Tips Amount - Current Year-to-Date |
| Wage Bonus Amount - Current Year-to-Date |
| Wage Bonus Amount - Previous Year-to-Date |
| Wage Commission Amount - Current Month-to-Date |
| Wage Commission Amount - Current Quarter-to-Date |
| Wage Commission Amount - Current Year-to-Date |
| Wage Commission Amount - Last Month-to-Date |
| Wage Commission Amount - Last Week |
| Wage Commission Amount - Previous Year Month-to-Date |
| Wage Commission Amount - Previous Year Quarter-to-Date |
| Wage Commission Amount - Previous Year-to-Date |
| Wage Hourly Overtime Amount - Current Month-to-Date |
| Wage Hourly Overtime Amount - Current Quarter-to-Date |
| Wage Hourly Overtime Amount - Current Year-to-Date |
| Wage Hourly Overtime Amount - Last Month-to-Date |
| Wage Hourly Overtime Amount - Previous Year Month-to-Date |
| Wage Hourly Overtime Amount - Previous Year Quarter-to-Date |
| Wage Hourly Overtime Amount - Previous Year-to-Date |
| Wage Hourly Regular Amount - Current Month-to-Date |
| Wage Hourly Regular Amount - Current Quarter-to-Date |
| Wage Hourly Regular Amount - Current Year-to-Date |
| Wage Hourly Regular Amount - Last Month-to-Date |
| Wage Hourly Regular Amount - Previous Year Month-to-Date |
| Wage Hourly Regular Amount - Previous Year Quarter-to-Date |
| Wage Hourly Regular Amount - Previous Year-to-Date |
| Wage Hourly Sick Amount - Current Month-to-Date |
| Wage Hourly Sick Amount - Current Quarter-to-Date |
| Wage Hourly Sick Amount - Current Year-to-Date |
| Wage Hourly Sick Amount - Last Month-to-Date |
| Wage Hourly Sick Amount - Previous Year Month-to-Date |
| Wage Hourly Sick Amount - Previous Year Quarter-to-Date |
| Wage Hourly Sick Amount - Previous Year-to-Date |
| Wage Hourly Vacation Amount - Current Month-to-Date |
| Wage Hourly Vacation Amount - Current Quarter-to-Date |
| Wage Hourly Vacation Amount - Current Year-to-Date |
| Wage Hourly Vacation Amount - Last Month-to-Date |
| Wage Hourly Vacation Amount - Previous Year Month-to-Date |
| Wage Hourly Vacation Amount - Previous Year Quarter-to-Date |
| Wage Hourly Vacation Amount - Previous Year-to-Date |
| Wage Salary Regular Amount - Current Month-to-Date |
| Wage Salary Regular Amount - Current Quarter-to-Date |
| Wage Salary Regular Amount - Current Year-to-Date |
| Wage Salary Regular Amount - Last Month-to-Date |
| Wage Salary Regular Amount - Previous Year Month-to-Date |
| Wage Salary Regular Amount - Previous Year Quarter-to-Date |
| Wage Salary Regular Amount - Previous Year-to-Date |
| Wage Salary Sick Amount - Current Month-to-Date |
| Wage Salary Sick Amount - Current Quarter-to-Date |
| Wage Salary Sick Amount - Current Year-to-Date |
| Wage Salary Sick Amount - Last Month-to-Date |
| Wage Salary Sick Amount - Previous Year Month-to-Date |
| Wage Salary Sick Amount - Previous Year Quarter-to-Date |
| Wage Salary Sick Amount - Previous Year-to-Date |
| Wage Salary Vacation Amount - Current Month-to-Date |
| Wage Salary Vacation Amount - Current Quarter-to-Date |
| Wage Salary Vacation Amount - Current Year-to-Date |
| Wage Salary Vacation Amount - Last Month-to-Date |
| Wage Salary Vacation Amount - Previous Year Month-to-Date |
| Wage Salary Vacation Amount - Previous Year Quarter-to-Date |
| Wage Salary Vacation Amount - Previous Year-to-Date |
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