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 ...

Get Power Query Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.