In this tutorial, you’ll learn how to use Power Query for currency conversions in Power BI. The method discussed in this blog will help you solve problems in your currency rates table using the last available rate. You’ll understand how to work things out when the currency rates table doesn’t have a currency rate on
In this article, we will review how to find the percent of the total calculation in Power BI. Although you might have already learned this from the other modules, reviewing it would be beneficial for its common usage in various scenarios. Percent Of Total In Total Sales To show you a simple example, we will
This blog is a review of the Power BI Quick Measure feature. As the name describes, this feature is a way of creating measures quickly. There are some pros and cons to this, which I will discuss in detail. I’ll also give you an example on how to use this feature. DOWNLOAD FILES USED IN
In this tutorial, I’ll show you a number of techniques that you can apply in showcasing your report in Power BI after learning various DAX functions. A thorough knowledge of important DAX functions can level up your data presentation. There are different ways to showcase your report in Power BI. But there’s certainly a great
In this tutorial, I’ll show you some advanced formulas and DAX examples using different functions in Power BI. Some of the functions that you’ll encounter in the examples below are CALCULATE, FILTER, MAX, ALLSELECTED, and many more. But before you begin, make sure to optimize your measures. I always recommend using measure groups to make
