Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • Presentations
    • Creative Aggregations
    • Debug DAX like a Pro
  • DAX Games
  • About Phil Seamark

Month: May 2019

A measure table called “Measures”

Posted on May 14, 2019July 8, 20198 Comments on A measure table called “Measures”

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

Posted on May 14, 2019July 8, 2019No Comments on TopNSkip Alternative

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

Search

Recent Posts

  • DAX Formatter tool for Power BI Desktop
  • Use Visual Studio Code to Auto-format JSON
  • Disable auto-format of JSON in SSMS
  • Use Visual Studio Code to create Power BI External Tool
  • Using Visual Studio Code to query Power BI

Archives

  • November 2020
  • October 2020
  • August 2020
  • July 2020
  • June 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • August 2019
  • July 2019
  • May 2019
  • May 2017
Phil Seamark on DAX

Back to top