The Power BI Gold for Purchasing dataset includes a large set of predefined measures. These measures have been organized into two main categories: Time Intelligence and Table measures. The table measures are described below.
Time Intelligence Measures
See Time intelligence measures in Power BI Gold.
Purchases Table Measures
Counters
| Measure Name | Description |
|---|---|
| No. of Invoiced Purchase Orders | Distinct count of documents where the document type is Purchase Invoice. |
| No. of Outstanding Purchase Orders | Distinct count of Purchase Orders where purchase lines with Outstanding Qty. is greater than zero. |
| No. of Received Not Invoiced Purchase Orders | Distinct count of Purchase Orders where purchase lines with Qty. Shipped Not Invoiced is not zero. |
Sales Measures
These measures are the base calculations used in the time intelligence measures.
| Measure Name | Description |
|---|---|
| Purchase Amount | Sum of Purchase Amount (LCY) |
| Purchase Quantity | Sum of Purchase Qty. (Base) |
Purchase Budget Table Measures
Budget Measures
| Measure Name | Description |
|---|---|
| Budget Amount | Sum of budgeted Amount |
| Budget Amount Variance | Difference of Purchase Amount and Budget Amount |
| Budget Amount Variance % | Percent of Budget Amount Variance and Budget Amount |
| Budget Quantity | Sum of budgeted Quantity |
| Budget Quantity Variance | Difference of Purchase Quantity and Budget Quantity |
| Budget Quantity Variance % | Percent of Budget Quantity Variance and Budget Quantity |