Data modelling and DAX
The next chapter in this series on Creative Aggs looks at Filtered Aggs, what they are, and how you might use them to speed up reports connected to Power BI and SSAS models. The series so far : Introduction to Aggs Horizontal Aggs Mixing Agg and base table to produce a single value Accordion Aggs … Continue reading Creative Aggs Part IV : Filtered Aggs
Introduction to Aggs Horizontal Aggs Mixing Agg and base table to produce a single value Accordion Aggs (this article) Variable grain aggs in a single table for extra flexibility Filtered Aggs Using Composite Models to keep recent data in memory, and older data in the source to optimise the model size Incremental Aggs A smart … Continue reading Creative Aggs Part III : Accordion Aggs
In this article, I’m going to describe a technique you may wish to consider to help speed up your Power BI reports. This specific technique is designed to help speed up reports that show common period comparisons such as: This year versus last year (as difference and/or percent) Delta, or percentage change over the previous … Continue reading Pivoting Data for Speed
I received an email recently asking for help with an interesting DAX question. The person was trying to get a DAX query working using the undocumented TOPNSKIP function to return a table of data that didn’t include the first N rows. The function syntax is as follows : TOPNSKIP ( <Rows>, <Skip>, <Table> [, <OrderByExpression> … Continue reading TopNSkip Alternative
