Tag: RANKX Function

Segmenting Dimensions Based On Ranking – Advanced Analytical Technique For Power BI

In this example, we’re going to get quite advanced in Power BI using DAX. We are going to focus on segmenting dimensions based on its ranking on that particular table. You may watch the full video of this tutorial at the bottom of this blog. This is an amazing concept of how you can utilize

Continue reading

Adding Workday And Weekend Numbers Into Your Date Table: Time Intelligence Technique In Power BI

This is a very unique example of Time Intelligence in Power BI, especially when working with workdays and weekends. You may watch the full video of this tutorial at the bottom of this blog. This tutorial came ftom a request from the Enterprise DNA Support Forum, where a member needed to get the day for

Continue reading

RANKX Considerations – Power BI And DAX Formula Concepts

RANKX is a very unique DAX function that requires a deeper level of thinking around its logic and in how it actually works when running a calculation in a particular context (for example a table or chart inside Power BI). You may watch the full video of this tutorial at the bottom of this blog. What

Continue reading

Power BI Dynamic Ranking By Group

Dynamic ranking in Power BI can be tricky if you don’t fully understand how it works. You might think that you got the formula right, but then you’d be surprised why you’re not getting the correct results. The key is to really understand the context that you’re working on and simplify your formulas. Knowing your

Continue reading

Showcasing Workday Number in Power BI Using DAX

We’re going to work through something really unique around Time Intelligence inside Power BI. This technique can help you track and determine the exact workday number in Power BI using a variety of DAX formula and advanced logic. You may watch the full video of this tutorial at the bottom of this blog. Getting around

Continue reading