Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Adam Aspin
About this chapter
Cite this chapter
Aspin, A. (2018). Adding Measures to the Data Model. In: Pro Power BI Desktop. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3210-1_12
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3210-1_12
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3209-5
Online ISBN: 978-1-4842-3210-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books