When working on your sales table, you might have information on the revenue, order quantity or unit price. But you do not have the data on profit margin. In this video, you will find out how to dynamically calculate profit margin so you can see what the profit margin is by customer, by store or by region.

***** Video Details *****
2:46 Calculating Total Costs using simple measures
3:25 Calculating Total Profits
4:22 Calculating Profit Margins
4:44 Changing Profit Margins to Percentage
5:11 Conditional formatting to change background color of the Profit Margin Column to show the highest to lowest.
6:52 Using grouping techniques to see the data that you only need

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi

FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax

FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources

FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/

Enterprise DNA Membership – https://enterprisedna.co/membership

Enterprise DNA Online – http://portal.enterprisedna.co/

Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

Read More

Share This