Monthly Archives: November 2021

Adding Contribution Range Visual

Posted on November 27, 2021 by alapitsk

It is often useful too add a gift bracket and then pivot and visualize those ranges. In the example below, I am adding a gift range and then visualizing what kind of gifts (small – large) generated most of the … Continue reading →

Posted in Dax Code Patterns | Tagged , , , | Comments Off on Adding Contribution Range Visual

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