<div>
I am not sure I can relate my answer to Excel Pivot, but Margin is always Calculated (Gross Revenue less Direct Costs). &nbsp;It is not (in my financial experience a Measure. &nbsp; Percent operating profit to Sales is a measure.
</div>


I am not sure I can relate my answer to Excel Pivot, but Margin is always Calculated (Gross Revenue less Direct Costs).  It is not (in my financial experience a Measure.   Percent operating profit to Sales is a measure.

<div>
Thanks I will follow that advice
</div>


<div>
<div class="content wysiwyg-content">
I am reading a book on Excel Power Pivot. &nbsp;I am struggling with when to use a measure and when to use a calculated column. &nbsp;If I want to calculate Margin as an example (Sale Price - Cost) do I do this as a Calculated column or as a measure ? &nbsp;Whats the best practive ?
</div>
</div>


I am reading a book on Excel Power Pivot.  I am struggling with when to use a measure and when to use a calculated column.  If I want to calculate Margin as an example (Sale Price - Cost) do I do this as a Calculated column or as a measure ?  Whats the best practive ?

Measures vs Calculated Columns - When to use ?

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.

Power BI

PowerPivot

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.