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