Tag: DAX Functions

Discover The INTERSECT Function In DAX And How To Utilize It – Power BI Tutorial

Discover The INTERSECT Function In DAX And How To Utilize It - Power BI Tutorial

The INTERSECT function in Power BI is an advanced table function and to understand how it works, you will want to get much better at understanding virtual tables. Virtual tables are a key concept when utilizing DAX measures within Power BI. What the INTERSECT function does specifically is that it allows you to – within a

Continue reading

Deep Dive Into RANKX – DAX Formula Concepts In Power BI

Deep Dive Into RANKX - DAX Formula Concepts In Power BI

RANKX is a very unique DAX function that requires a deeper level of thinking around its logic and also in how it actually works when running a calculation in a particular context (for example a table or chart inside of Power BI). Each different parameter within the RANKX function can change the way in which it

Continue reading

Implementing DAX Measure Groups Into Your Power BI Reports – Modeling Review

Implementing DAX Measure Groups Into Your Power BI Reports - Modeling Review

I want to touch on a really important topic within this tutorial. In many of the showcase demos that Enterprise DNA releases across webinars, summits, and to Enterprise DNA members you will see that the use of measure groups is extensive. There is a very good reason why measure groups have been implemented in all

Continue reading

Cumulative Totals In Power BI Without Any Dates – Advanced DAX

Cumulative Totals In Power BI Without Any Dates - Advanced DAX

In this example, I’m going to show how you can create Cumulative Totals which are not over dates in Power BI. To create cumulative totals over dates inside of Power BI is not too difficult. There’s a set of formula pattern that you can utilize and reuse for whatever type of cumulative total results you

Continue reading

How To Start Using ‘What If’ Parameters Inside Power BI

How To Start Using 'What If' Parameters Inside Power BI

In this tutorial, I will show you how you can get started with ‘What If’ parameters inside of Power BI. Using this great feature will require you to spend some time thinking quite deeply about the data setup that you currently have in your data model. ‘What If’ parameters have to work over certain values

Continue reading