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
Tag: Query Editor
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. 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,
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
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