DAX HAI I HAVE PROFIT ,SALES AND QUANTITY HOW TO CALCULATE THE COST PRICE OF THE PRO

[R_Ambica]

how to calculate the cost price when sales,profit and quantity is given in the table please anyone help me to get this issue resolve

[FarhanAhmed · Accepted solution]

You can create a calculated column to get the Cost Price

Cost Price per Unit= Divide([Sales],[Quantity]) - Divide([Profit],[Quantity])

[AliceW]

Something like this. Say you have:

Sales = 5000 Euros

Profit = 100 Euros

Quantity = 200 pieces

We deduce that:

Cost = Sales - Profit = 4900 Euros

Cost per unit = Cost / Quantity = 24.5 Euros

[Idrissshatila]

Yes like this.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Idrissshatila]

Hello,

so you could add a column and make a measure Cost = sales - Profit

and to get cost per item = Cost / quantity

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin