In this tutorial, you’ll learn the general strategies to improve your DAX or M capabilities. This is an opportunity to learn and understand each Power BI DAX function. In Power BI, there are specific elements of practice that you have to learn to be proficient with functions. If you utilize these strategies, you’ll be able
I’m going to show you how to create custom tiebreakers when using RANKX in Power BI. Getting a tie in a critical portion of RANKX results is a common scenario. There are a number of tiebreakers you can use but it’s important to choose the one that makes the most sense for each situation. The
In this article, I am going to talk about time intelligence functions in Power BI. We have already touched on a previous example with the fields Date, Total Sales, and Sales Last Year. As you can see, there is no data in Sales LY prior to 2019. In the DAX Formulas Reference Guide, you can
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
I want to introduce you to a group of functions in Power BI called table functions. These functions include FILTER and ALL which we already used or mentioned in other topics. There is a whole range of other table functions which includes functions like VALUES, TOPN, and ADDCOLUMNS. However, we are not going to cover
