Tag: Advanced Editor

Referencing And Duplicating Queries In Power BI

Referencing And Duplicating Queries In Power BI

Referencing and duplicating are two different actions. In this tutorial, we’re going to discuss the difference between referencing and duplicating queries in Power BI. Right click on anything in the Queries pane. Then, we’ll see that we have Duplicate and Reference options. One of the differences between Reference and Duplicate is what happens inside the

Continue reading

Create a Perpetually Updated Practice Dataset in Power BI

I’m going to show you how to keep your practice dataset updated every time you do a refresh. If you really want to improve your DAX skills, the way way is to use it and put it into practice. And to do that, you’d need a practice dataset that helps you visualize and work on

Continue reading

M Function For Date Table – How To Add A Parameter In The Query Editor

I’m going to show you how to add a parameter in the M function in your date table query. This example is based on a question that was raised on the Enterprise DNA Forum. The question was about how to switch the numbering of the 1st day of the week from 0 to 1. Note

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

The Importance Of Power BI Date Tables

The Importance Of Date Tables In Power BI Enterprise DNA

When working on Power BI 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.

Continue reading