Category: Query Editor

How To Download Exchange Rates In Power BI

I’m going to show you in this tutorial how you can download exchange rates into your Power BI data model. This is perfect if you need to bring in the latest exchange rates for some evaluation work or for financial reports where you have to deal with sales from a variety of different regions around the

Continue reading

Showing Results Before Or After A Selected Date Using DAX

Showing Results Before Or After A Selected Date Using DAX

As we work through this tutorial, I will show you some truly powerful analytics that you can complete inside of Power BI. What we are attempting to analyze here is the information around a selected date. We are going to look at a specific time frame , and then look at a range of days

Continue reading

Comparing Any Sale Versus The Last Sale (No Time Intelligence) – Advanced DAX In Power BI

In this unique example, I’ll show you an advanced DAX technique in Power BI wherein we 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 day or if you’re looking at a particular customer or a product and

Continue reading

How To Set Up Your Financial Data in Power BI

Financial reporting is a very essential tool to communicate past successes as well as future expectations in a company. When you need to complete a financial analysis, you need to set up your financial data in Power BI in a compelling way. It doesn’t matter if your data is from the revenue side, the expense

Continue reading

My Practice Tips When Using The Power BI Advanced Editor

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