Tag: DAX Functions

5 Strategies To Enhance Your Power BI DAX Skills

5-Strategies-To-Enhance-Your-Power-BI-DAX-Skills

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

Continue reading

RANKX In Power BI – Developing Custom Tiebreakers

Develop Custom Tiebreakers in RANX Power BI and DAX

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

Continue reading

Power BI Time Functions: DATEADD And More

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

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

Using Table Functions In Power BI

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

Continue reading