Tag: Power Query

Power Query Tools, Tabs, And User Interface

Power Query Tools, Tabs, And User Interface

This tutorial will discuss about Power Query tools and ribbons. You’ll learn how to be efficient in data modeling and will know your way around the editor. You’ll also learn about the different tabs, ribbons, and context menus and how they can help you achieve the perfect Power BI data report. Power Query Tools And

Continue reading

Power BI Values And Literals – Understanding The Basics

Introducing-Values

In this tutorial, you’ll learn about Power BI Values and how they are generated inside the Power Query Editor. These values have corresponding literals that can be used in codes and expressions to produce results and data. You’ll also learn how and where to apply the values to build a compelling report. Power BI Values

Continue reading

M Language and Power Query Editor In Power BI

_M-Language-and-Power-Query-Editor-In-Power-BI

In this tutorial, you’ll learn about Power Query and M language and how to master them. This will also discuss their use inside the Power BI desktop. You’ll learn and understand their importance in developing and obtaining data for your Power BI reports. The Power Query Editor Power Query is designed for data transformation and

Continue reading

Perpetual Holiday Calendar – POTW #12 (Power Query Solution)

Perpetual Holiday Calendar – POTW #12 (Power Query Solution)

In this blog post, we’ll explore my solution to Problem of the Week #12. For this challenge, we revisited Enterprise DNA’s maiden Problem of the Week challenge, where we created a perpetual holiday calendar from a mix of specific and relative dates. But this time around, we will be using only Power Query. You can

Continue reading

Power Query/M Masterclass #1 – New Course on Enterprise DNA

We’re ending June with a bang by introducing a new course on the Enterprise DNA Education Platform — the 1st of many installments of the Power Query/M Masterclass. Those who will sign up for this course is in for a real treat because Enterprise DNA Expert Melissa de Korte will be hosting this class. Those

Continue reading