Tag Archives: dax

Ranking Donors. Breaking Tie.

Posted on January 10, 2022 by alapitsk

I recently run into an issue when I needed to select the top 5 donors based on the contribution amount by occupation. The process is not that complex, however, for certain occupations, a large number of donors had the same … Continue reading →

Posted in Dax Code Patterns | Tagged , , , , | Comments Off on Ranking Donors. Breaking Tie.

First Month Gifts Using Generate Function

Posted on December 28, 2021 by alapitsk

Often we need to derive first-month sales/donations. In the sample dashboard that I built using public FEC data, there are donors with multiple donations. The formula below allows determining donations in the first month since the first donation in a … Continue reading →

Posted in Dax Code Patterns | Tagged , , , , | Comments Off on First Month Gifts Using Generate Function

Donors With Multiple Gifts

Posted on December 20, 2021 by alapitsk

Often we need to derive donor with multiple gifts grouped by other dimensions. In the example below, I am adding a count of donors in a specified range from a zip code who made multiple donations. The dashboard example is … Continue reading →

Posted in Dax Code Patterns | Tagged , , , | Comments Off on Donors With Multiple Gifts

Using CrossFilter To Alter Relationship

Posted on November 14, 2021 by alapitsk

I recently came over an example of CROSSFILTER function in DAX. While not very common I can see a lot of potential in certain circumstances. Essentially, in a measure, it temporarily alters relationships. In most cases, there is a fact … Continue reading →

Posted in Dax Code Patterns | Tagged , , , | Comments Off on Using CrossFilter To Alter Relationship

DAX Retention Year Over Year Pattern

Posted on November 10, 2021 by alapitsk

Often we need to write many lines of code in SQL to derive retention year over year. Generally, we join the main fact table to itself and then add a condition that a donor this year has to also be … Continue reading →

Posted in Dax Code Patterns | Tagged , , , | Comments Off on DAX Retention Year Over Year Pattern

Cleaning Up Tabular Models

Posted on September 26, 2021 by alapitsk

When I started at my current job, much of the new Power BI development occurred in one giant tabular model. At some point, the model had almost 1200 measures. Having so many measures in the model made it hard to … Continue reading →

Posted in Tabular Models | Tagged , , , , | Comments Off on Cleaning Up Tabular Models