Extending the Data Model with Calculated Columns

  • Adam Aspin


Admittedly, not every data model in Power BI Desktop needs extensive calculations. Frequently, the data can speak for itself without much polishing. Yet business intelligence is, at its heart, based on figures. Consequently, sooner or later, you need to apply simple math, calculate percentages, or compare figures over time. You may even want to develop more complex formulas that enable you to extend your analyses and illustrate your insights. Fortunately, Power BI Desktop makes these—and many, many other calculations—amazingly easy. What’s more, if you are an Excel user, you will probably find most of the techniques explained in this chapter to be totally intuitive.


Data Model Data View Stock Table Special Sale Modeling Ribbon 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Adam Aspin 2016

Authors and Affiliations

  • Adam Aspin
    • 1
  1. 1.Stoke-on-TrentUK

Personalised recommendations