DAX Archives - Page 7 of 7 - Phil Seamark on DAX

Speed up Power BI reports using columns

July 8, 2019July 8, 20196 Comments

Did you know, in some cases, it is possible to add columns to your model to speed up the DAX used behind visuals to make them as much as 100 times faster? The PBIX helper file for this article can be downloaded here. I have come across this scenario a few times recently, so thought … Continue reading Speed up Power BI reports using columns

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