how to write this formula in PowerBI ?

[usman96]

I have written a formula in Tableau  which is this

([Per Unit Price ($)]-[Per Unit Cost ($)])*[Units Sold]

now i want to write in powerbi  

can someone show me how to write it in PowerBI

[bsas · Accepted solution]

Hi,

It depends if you want to use calculated column or measure. For calculated column just write: test_column = (unit price - unit cost)*Units sold. In case of measure: test_meamure = (sum(unit price) - sum(unit cost))*sum(unit sold).