Measure Summary
This reference lists the visible DAX measures included in the prepared QQube Fixed Assets examples for Power BI and Excel Power Pivot. The measures support asset cost, depreciation, book value, purchases, sales, and asset-count analysis.
Data Model Fixed Assets | Reference Type DAX measure reference |
Visible Measures 17 | Display Folders 3 |
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 (7 measures)
- Asset Related Measures (1 measure)
- Calendar Pattern Measures (9 measures)
.Base Measures
Base calculations for accumulated depreciation, asset count, cost basis, purchase cost, sales expense, sales price, and year-end book value.
| Measure Name |
|---|
| .Accumulated Depreciation |
| .Asset Count |
| .Cost Basis |
| .Purchase Cost |
| .Sales Expense |
| .Sales Price |
| .Year End Book Value |
Asset Related Measures
Asset-level calculations for depreciation analysis.
| Measure Name |
|---|
| Percent Depreciated |
Calendar Pattern Measures
Fixed-asset values summarized by month or year, including depreciation, asset count, book value, cost basis, purchases, and sales.
| Measure Name |
|---|
| Accumulated Depreciation - Yearly |
| Asset Count - Yearly |
| Book Value - Year End |
| Cost Basis - Yearly |
| Purchase Cost - Monthly |
| Purchase Cost - Yearly |
| Sales Expense - Yearly |
| Sales Price - Monthly |
| Sales Price - Yearly |
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