cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TomasPac Frequent Visitor
Frequent Visitor

How to get percentile column

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

1 REPLY 1
Stachu Super Contributor
Super Contributor

Re: How to get percentile column

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 6 members 1,811 guests
Please welcome our newest community members: