Tag: power query editor

Record Values – Structured Value In Power Query

Record Values – Structured Value In Power Query

This tutorial will discuss about record values inside the Power Query Editor. You’ll learn how to create and use records with different expressions to generate the results you want to achieve. Creating Record Values A record value is an ordered sequence of fields. It is made up of a set of fields that consists of

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

Power Query Data Types And Connectors

Power Query Data Types And Connectors

This tutorial will talk about Power Query data types and connectors. You’ll learn what data types are and see how they are compatible with each other. You’ll also learn about operators in the Power Query M Language. These will help you understand how your queries generate results and answers. The Data Types In Power Query

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

Format Data In Power BI: Addressing Irregular Data Formats

Format Data In Power BI- Addressing Irregular Data Formats

In today’s blog post, we’ll discuss Problem of the Week #6. I’ll show you how to format data in Power BI involving the use of power query. The screenshot below is the solution that you should have after you’ve done all the data transformation. The actual balance number was $685,616.33. You can watch the full

Continue reading