There's a great DAX Patterns site example for creating measures that can allow you to compute net sales for the base period vs net sales for the measurement period. The basic principal is comparing unit prices invoiced per product between a base period and a measurement period, such as prior calendar year vs current first quarter. I'm attempting to recreate some purchase price comparison reports that are currently hosted in a dynamic SQL-based tool (IBM Cognos). I need help handling whether it's possible for two measures with different filter context to be used in an 'Average of Net Difference' type of measure, especially when comparing different time periods and needing to force calculations at a unit level. A customer in retail should calculate the unit price to know what he is paying for a single item or a pound of food item, rather than looking at the total quantity of the product he is buying.See my adapted example file at Github GMeronek Variation SQL BI 05 01 Comparing different time periods.pbix.On the other hand, unit cost is what holds significance for a manufacturer, as he strives to keep it down so as to generate more profits and more sales. Unit price is what is important from the customer’s point of view.Unit cost is the cost incurred on producing and packing a single piece of item, whereas unit price is the price of a single piece of item.What is the difference between Unit Price and Unit Cost? In general, unit cost is higher for a small manufacturer while it is lower as the manufacturing company becomes bigger through sheer economy of scale. The lower the unit cost, the item becomes more competitive and sells in higher numbers, with all other factors being constant. Unit cost is the cost incurred on producing and packing a single piece of item and is useful for a manufacturer as it allows him to decide on the unit price to be sold in retail, keeping in mind the selling price per unit to retailers and allowing for a decent margin to them, as well. What one must look or calculate while shopping is the unit price and not the price of packing that may contain several units. If you are paying $1 for a 200g packing and the 500g packing has a price of $2, you are actually getting the advantage of economy of scale by getting 100g free. So the next time you are in a shopping mall and see a bigger packing of talcum powder that is also costlier than your regular packing, do not feel that you are being charged more for the packing. Unit price is for retail customers only, and they know how much they are paying for a single piece even if they are buying more than one piece at a time. This is where the concept of unit price comes into play. The price of this packing is, however, lower than 3 times the price of the single pieced packing. However, in another shelf there is a bigger packing of another company that contains 3 pieces of the same food item.

When you are in a shopping mall, buying groceries, you get to see a food item for a particular price. For readers who cannot appreciate the significance of unit price and unit cost, this article attempts to highlight the differences between these two types of prices. While unit price is important from the point of view of retail customers shopping in malls and shops, unit cost is a feature holding significance for manufacturers as it is in their interest, to keep unit cost down to the minimum to have bigger sales. Unit price and unit cost are two related terms that are confusing for many.

Price unit calculator