O'Reilly logo

Pro Power BI Desktop by Adam Aspin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Adam Aspin 2016

Adam Aspin, Pro Power BI Desktop, 10.1007/978-1-4842-1805-1_8

8. Adding Measures to the Data Model

Adam Aspin

(1)Stoke-on-Trent, Staffordshire, UK

Adding new columns can provide much of the extra data that you want to output in tools like Power BI Desktop . It is unlikely, however, that this approach can deliver all the analyses that you need. Specifically, calculated columns can only work on a row-by-row basis; they cannot contain formulas that have to apply to all or part of the records in a table. For instance, counting the number of cars sold for a year, a quarter, or a month has nothing to do with the data in a single row in the Stock table. It does, however concern the table as a whole.

Generally, you need to add a second ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required