May 2019 – Phil Seamark on DAX

A measure table called “Measures”

May 14, 2019July 8, 20198 Comments

I wrote a blog back in 2017 on how to better organise your measures in Power BI. One thing that bothered me at the time was I wasn’t able to give the measure table the one name I truly wanted. The perfect name for a measure table is, of course, Measures. Unfortunately, this is a … Continue reading A measure table called “Measures”

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