Tag: Query Editor

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

The Importance Of Date Tables In Power BI

The Importance Of Date Tables In Power BI Enterprise DNA

When working on date tables, it’s important to know the essential techniques so you can set things up as quickly as possible. In this tutorial, I’ll go over some important tips that can help you. The date tables are important in Power BI because you’ll need them to reference dates inside your model. On top

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

Advanced Transformations in Power BI

Let me discuss some advanced transformations in Power BI through the query editor. Remember that you can combine different actions within the query editor to fully optimize your models. It’s just a matter of familiarizing yourself with the different transformations in Power BI and finding out what scenarios they’re useful for. Exploring The Different Transformations

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