Tag: M Functions

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

Unpivot Multiple Columns Dynamically In Power BI

Unpivot Multiple Columns Dynamically In Power BI

In this tutorial, we’ll revisit a topic I covered earlier about how to unpivot multiple columns in Power Query using List.Zip. An Enterprise DNA member asked on the forum on how to make that method dynamic. You may watch the full video of this tutorial at the bottom of this blog. I’ve labeled this advanced

Continue reading

Combinatorial Analysis Using Power Query In Power BI

Combinatorial-Analysis-Using-Power-Query-In-Power-BI

I want to do a deep dive into something called combinatorial analysis. This can be defined as the choosing and arranging of elements of sets in accordance with prescribed rules. It might sound esoteric, but it’s actually got some very practical use cases. You may watch the full video of this tutorial at the bottom

Continue reading

Power Query M: Alternating 0-1 Pattern In Date Table

Power-Query-M-Alternating-0-1-Pattern-In-Date-Table

This tutorial focuses on using the Power Query M number.mod function to create an alternating 0-1 pattern in the Date table. The solution that I’m going to show you came from one of our community power users, Rajesh, at Enterprise DNA. You may watch the full video of this tutorial at the bottom of this blog.

Continue reading