Category: Query Editor

How To Use The EARLIER Function In Power BI – A DAX Tutorial

Most DAX beginners and even intermediate users really struggle in understanding what the EARLIER function does. It also took me a long time to understand how, when and why you should use this function in Power BI. In this article, we are going to complete a deep dive into using the EARLIER function. I’ll show you

Continue reading

Power BI Query Parameters: Optimizing Tables

Query parameters are a really strong feature in Power BI. There are many places that you can implement filters in Power BI, but on some occasions, it’s better to do this at the query layer versus the report level. You might want to create filters at the query level if you have massive tables from

Continue reading

Build A Comprehensive Date Table In Power BI Really Fast

Enterprise DNA Power BI Video Tutorial Create a Detailed Date Table Fast

In this post, I’m going to show you what is probably the quickest and most effective way to create a detailed date table in Power BI. If you want to analyze anything over time, there is likely no more important table to create for any Power BI model than a great date table. Creating The

Continue reading

How To Download Latest Exchange Rates Into Your Power BI Model

I’m going to show you in this tutorial how you can download exchange rates into your Power BI data model. These, in theory, should also automatically update as they are updated on the website where we are drawing from. This will be perfect if you have a requirement to bring in the latest exchange rates for

Continue reading

Unpivot And Pivot Basics In Power BI – Query Editor Review

There are many occasions where you may bring data into Power BI and the data structure is not optimized for your data model. In this article, I’m going to work through when you should utilize the unpivot or pivot feature within your data queries. One thing to bear in mind early on when working on

Continue reading