Medium Archives - Page 4 of 4 - Phil Seamark on DAX

Pivoting Data for Speed

October 16, 2019October 25, 2019No Comments

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

TopNSkip Alternative

May 14, 2019July 8, 2019No Comments

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