Tag: Query Editor

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. DOWNLOAD FILES USED IN THIS ARTICLE We want to make sure that when we import this Excel data into our Power

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. The best practice when designing a model is to check for date fields. If they are present, always include a date dimension table. A Date Table includes all the attributes that you may want to slice, dice,

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. It’s important that your models are as intuitive as possible. Not only will this make it easier for you to work on your models, it will also make it easier for other people to jump in

Continue reading

Creating A Date Table In Power BI

The importance of creating a date table in Power BI is something that people often miss, especially in the Enterprise DNA forum. Although it’s common to have a date column in your sales tables and transaction tables, that won’t be enough. You’ll need a separate date table that you can link to all those other

Continue reading