Tag: Query Editor

Power BI Power Query: Removing Duplicate Rows

In this blog, I’ll show you how to remove duplicate rows in the Power BI Power Query based on conditions. You may watch the full video of this tutorial at the bottom of this blog. This example is from a question that was raised on the Enterprise DNA Forum. The member has transactional data and

Continue reading

Power BI Datasets: Types And Naming Conventions

Format Data In Power BI Using The Query Editor

In this tutorial, I will discuss Power BI datasets, including data types and the importance of naming conventions. The data used in this example is a resource pack made available for Enterprise DNA members. We want to make sure that when we import this Excel data into our Power BI model, we get an error-free

Continue reading

How To Use A Measure Table In Power BI

In today’s blog post, I’ll discuss some techniques on how to organize measures using a measure table in Power BI. The best way to organize your measures is to create measure groups or measure tables inside Power BI.  It’s important to learn this technique because you’ll be dealing with hundreds of measures in your analysis.

Continue reading

Using The M Function To Create An Extended Power BI Date Table

This tutorial will cover about the most important Power BI dimension table in any model, the Date Table. You may watch the full video of this tutorial at the bottom of this blog. The best practice when designing a model is to check for date fields. If they are present, always include a date dimension

Continue reading

Organizing Your Queries: Power BI Query Editor Tutorial

In this quick Power BI query editor tutorial, you’ll learn how to organize your queries to create intuitive models. You may watch the full video of this tutorial at the bottom of this blog. It’s important that your models are as intuitive as possible. Not only will this make it easier for you to work

Continue reading