Chapter 8: Adding Value to Your Data
You have the chance to connect to your data and create and transform it as you want thanks to a wide range of options explored in the previous chapters. Moreover, Power Query offers the chance to add data and enrich it with additional columns or define some functions to retrieve data. By adding columns, you can define your own customized logic in a few steps and leverage the UI or M code expressions, which represents the language behind the scenes of Power Query. M code expressions can be used to build functions and define input values and programmatically retrieve a defined output in order to simplify the entire transformation process.
In this chapter, you will explore how you can add data as new columns based on a pattern or a logic of existing data enriching it with valuable information and using a set of transformations.
In this chapter, we will cover the following recipes:
- Adding columns from examples
- Adding conditional columns...