© Markus Ehrenmueller-Jensen 2020
M. Ehrenmueller-JensenSelf-Service AI with Power BI Desktophttps://doi.org/10.1007/978-1-4842-6231-3_8

8. Creating Columns from Examples

Markus Ehrenmueller-Jensen1 
(1)
CEO, Savory Data, Alkoven, Austria
 

Power BI comes with a powerful tool (called Power Query) with which to import and clean data from different sources. The power of this tool derives from a powerful language: Power Query Mashup Language, or M for short. Instead of digging into the manual to learn the syntax of this language and finding the right functions to achieve your goal, you can transform data by just giving examples of what the new column should look like. A similar user experience is available for web scraping, if you want to load data from ...

Get Self-Service AI with Power BI Desktop: Machine Learning Insights for Business 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.