Category: Query Editor

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

Build A Comprehensive Date Table Really Fast in Power BI

Build A Comprehensive Date Table Really Fast in Power BI

If you want to analyse anything over time, there is likely no more important table to create for any Power BI model that a great date table. I rarely, if ever, run any time analysis over date tables in fact tables. I always create a date table and then build a relationship over to the fact

Continue reading

Compare One Sale Versus The Last Sale (No Time Intelligence)

Compare One Sale Versus The Last Sale (No Time Intelligence)

In this unique example, I will show you how you can compare a sale, on any particular day to the very last sale that was made. This will be relevant if you don’t actually sell something every single day or if you are looking at a particular customer or a product and you want to

Continue reading

My Practice Tips When Using The Advanced Editor in Power BI

We’re going to talk about some of my best practice tips using Advanced Editor inside Power BI. Surprisingly, most people don’t know about the Advanced Editor. It is because it’s hidden away inside the Query Editor which a lot of users don’t utilize as much as they should. If you don’t know what it is, you

Continue reading