Tag Archives: Power BI

Simple Things To Reduce The Size Of Model

Posted on April 8, 2025 by alapitsk

One of our tabular models kept failing due to memory allocation. The model sourced email results and texting results. Over time, it grew to 30 gigabytes and kept growing. The model supported 4 reports and was basically ingesting transactional data. … Continue reading →

Posted in Modeling and Data Sources | Tagged , | Comments Off on Simple Things To Reduce The Size Of Model

My Original Thoughts Regarding MS Fabric

Posted on October 19, 2024 by alapitsk

After spending some time exploring MS Fabric from the perspective of a mid-size nonprofit, here are my initial observations. It is a well-put-together and powerful tool that can serve well to the right organization. On the other hand, it is … Continue reading →

Posted in MS Fabric | Tagged , , , , | Comments Off on My Original Thoughts Regarding MS Fabric

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