Tag: Power Query Tables

Power BI Filtering Techniques For Tables

Power BI Filtering Techniques For Tables

In this blog, we’re going to learn about some essential Power BI filtering techniques for tables. We’ll discuss some simple techniques that we can utilize when we have massive tables on our query.  For example, when we need to extract information from a database or an ERP system, it could have 10 million rows within

Continue reading

Query Editor In Power BI | An Overview

WHAT'S POSSIBLE WITH THE QUERY EDITOR

In this tutorial, we’ll show a detailed example of why we always need to use the Query Editor in Power BI and what we can achieve when using it.  It’s deemed a best practice to always bring your data into the Query Editor first. We’ll show and prove it by running through some examples and

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

Table Value – A Common Structured Value In Power BI

Table Value - A Common Structured Value In Power BI

This tutorial will discuss about table value. It’s one of the most common structured values that you can encounter in many Power BI data reports. You’ll learn how to build tables using different expressions in order to obtain specific information and make your report insightful. Creating A Table Value Think of tables as a list

Continue reading