How to get percentile column

[TomasPac]

Hello, I have a table which shows sales, purchases, and profit (sales minus purchases) grouped by date column. Table is related to a different table which has site names. So by that i calculate how much each site spends and makes sales. What  I need is a new column which would show percentage of purchases against sales. The syntax would look something like sales minus purchases = profit divided by sales which is 100% and I need everything shown in %. Thank You

[Stachu]

if you want to see percentages most likely you need a measure not a calculated column - this article describes the difference between the two:

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

I'd create following measures:

Sales Amount = SUM(Table[Sales])

Purchases Amount = SUM(Table[Purchases])

Profit = DIVIDE([Sales Amount]-[Purchases Amount], [Sales Amount])

adn then you format the measure accordingly