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. This is an amazing concept of how you can utilize calculated columns within Power BI. This can bring additional insights that would have never been

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. This tutorial came ftom a request from the Enterprise DNA Support Forum, where a member needed to get the day for each weekday and the day of each weekend into their Date table. I’ve seen this

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). What you don’t want with RANKX DAX function is to start receiving results and not really

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. Getting around this analysis can help solve an issue around comparing and counting working days in a

Continue reading