Tag: M Language

Power Query M Language Tutorial And Mastery

Power Query M Language Tutorial And Mastery

This tutorial will discuss about how to successfully implement a piece of M code and solve common errors inside the Power Query Editor. You’ll also learn how to effectively practice and master the M language in Power Query. Power Query M Language Implementation The success of implementing a piece of M code depends on how

Continue reading

Power Query Functions, Keywords, And Identifiers

Power Query Functions, Keywords, And Identifiers

This tutorial will discuss Power Query functions, keywords, and pre-defined identifiers. You’ll learn what they do and how to use them in developing codes and formulas. You’ll also learn how to access function documentation to get information and examples for your report. Keywords And Pre-Defined Identifiers Keywords and Pre-Defined Identifiers can’t be redefined. This is

Continue reading

How To Use Power Query Row And Column Selection

How To Use Power Query Row And Column Selection

This tutorial will discuss how to use selection and projection inside the Power Query Editor. Selection is for selecting a row; projection is for selecting a column. You’ll learn and understand how to use them to obtain data and information from a table. How To Use Power Query Row Selection The positional index operator is

Continue reading

Power Query Features: An Overview

Power Query Features: An Overview

This tutorial will discuss about the available features inside the Power Query Editor. You’ll learn how to access and maximize these features in order to improve your data development skills in Power BI. You’ll also learn how these power query features will help you build data reports more efficiently. The Advanced Power Query Editor And

Continue reading

Variables And Expressions Inside Power Query Editor

Variables-And-Expressions-Inside-Power-Query-Editor

This tutorial will discuss about variables and expressions inside the Power Query Editor. You’ll see and learn that each let expression has two parts: a let and in clause, and a comma-separated list of variable names or step identifiers. You’ll also see how these things help create a data report in the Power Query Editor.

Continue reading