Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • DAX Games
  • About Phil Seamark

Tag: TOPN

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

Categories

  • Advanced
  • Aggregations
  • Analysis Services
  • Blog
  • Calculation Groups
  • Columns
  • Composite Models
  • Data Modelling
  • DAX
  • Direct Query
  • Distinct Count
  • Easy
  • Filtering
  • Inventory
  • Medium
  • Optimise
  • Performance
  • Power BI
  • Power BI Refresh
  • PowerShell
  • Relationships
  • SSMS
  • Time Intelligence
  • TMSL
  • TOM
  • Uncategorized
  • VS Code

Recent Posts

  • Speed up Distinct Count calculations in Power BI using Aggregations
  • Using PowerShell to create Calculation Groups in Power BI Desktop
  • Power BI Storage Modes for Aggregations
  • Power BI Multiple Aggregations tables
  • Intro to Power BI Aggregations
Phil Seamark on DAX

Back to top
 

Loading Comments...