In this tutorial, I’ll demonstrate how you can calculate percentage margins using DAX. Probably one of the most common metrics in sales and revenue analysis and reporting, this is something I consider to be quite straightforward if you’ve been using Power BI for some time. But if you’re just starting out, this could be challenging to piece together.

Sam

***** Video Details *****
00:00 Introduction
00:48 The data model
01:31 The sales table
02:10 Total sales
02:53 Total cost with SUMX
03:49 Total profits
04:08 Profit margins
04:48 Sam’s tips
05:52 Conditional formatting
07:01 Changing visualization

***** 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/

#EnterpriseDNA #PowerBI #DAX #DAXTutorial #PercentageMargin #MeasureBranching