Tag: m language power query

Adding Data In Power BI | A Power Query Tutorial

As we know, data has a lot of different forms before we can retrieve and bring it in Power BI. Power Query offers several advantages when it comes to importing and consolidating Power BI data. In this blog, we’ll discuss the different ways on how we can bring data in Power BI. Think of Power

Continue reading

Comparing Tables In Power Query | Power BI Tutorial

Comparing Tables In Power Query | Power BI Tutorial

Comparing tables is a very common task in Excel and can get tedious if you do it manually all throughout. In this tutorial, I’ll show how you can easily compare two tables in Power Query to isolate the items that do not appear on both tables and report the differences. You can watch the full

Continue reading

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 Language Flow Best Practices

Power Query Language Flow Best Practices

In this tutorial, you’ll learn about the Power Query Language Flow and some of its best practices. You’ll also learn how to transform your data easily to get the best possible results. Data transformations will optimize your report and make it look compelling. Set Data Types With No Power Query Language Flow The bare minimum

Continue reading

Function Query And Operators In The Query Editor

Function Query And Operators In The Query Editor

This tutorial will discuss the Function Query feature in the Query Editor. You’ll learn how to use and maximize function queries to get the results and data you desire. You’ll also understand how they work with operators to generate specific outcomes. Creating A Function Query Power Query allows users to define custom functions which map

Continue reading