How To Do Projection In Power Query/M Language

preview_player
Показать описание
The field-access expression is used to select a value from a record or to “project” a record or table to one with fewer fields or columns, respectfully. In this tutorial, Melissa is going to delve into Projection in the Power Query/M Language, what it means, and how you can use it.

***** Video Details *****
00:00 Introduction
00:47 BaseRecord
01:50 Record.SelectFields
03:15 BaseTable
03:53 Table.SelectColumns

***** Learning Power BI? *****

#EnterpriseDNA #PowerQuery #PowerQueryTutorial #PowerBI #PowerBIDesktop #PowerBITutorial
Рекомендации по теме
Комментарии
Автор

Amazing how much I learned here in 5 minutes from the simplest possible 2x2 table. Melissa is the best!

brianjulius
Автор

Love how Melissa takes large concepts in M and breaks them down to make them understandable. While projection is not a concept that the average new user will be ready to worry about, it is a great tool for advanced users who are ready to start editing functions.

heatherr
Автор

Thank you Melissa! So amazing the way you share your knowledge. You Rock! 😊

malejandrahorvath
Автор

Thanks Melissa. Really like your live session on "Clean Your Data Like A Pro". You always amazes us with your M Wizardry. Thanks again.

qasimjan