In the previous two chapters, you saw how to hone your dataset so that you only used the rows and columns of data that you really need and then how to cleanse and complete the data that they contain. In this chapter, you will learn how to build on these foundations to deliver data that is ready to be molded into a structured and useable data model.
The generic term for this kind of data preparation in Power BI Desktop is data mashup. It covers the following:
Extending datasetsby adding further columns. These will nearly always be derived from existing columns of data. You could extract years or months from ...
