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
Purchases Table Measures
|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.|
These measures are the base calculations used in the time intelligence measures.
|Purchase Amount||Sum of Purchase Amount (LCY)|
|Purchase Quantity||Sum of Purchase Qty. (Base)|
Purchase Budget Table Measures
|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|