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
Tag: 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
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.
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
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