Tag: Power BI DAX

Solving Missing Currency Rates With Power Query In Power BI

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

Continue reading

Finding The Percent Of Total In Power BI

Finding The Percent Of Total In Power BI

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

Continue reading

Power BI Quick Measure Feature

Power BI Quick Measure Feature

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

Continue reading

Showcase Report In Power BI Using DAX Techniques

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

Continue reading

DAX Examples In Power BI – Advanced DAX Formulas

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

Continue reading