Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • DAX Games
  • About Phil Seamark

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

Power BI and Regular Expressions

Posted on May 23, 2017May 24, 20175 Comments on Power BI and Regular Expressions

I read a quote somewhere along the lines of… If you are trying to solve a problem with regular expressions… you now have two problems This seems a little harsh for a useful tool that has been with us for what seems a very long time.  Plenty of languages offer support for RegEx string searching … Continue reading Power BI and Regular Expressions

Dynamic distances in Power BI

Posted on May 13, 2017May 23, 20175 Comments on Dynamic distances in Power BI

How to dynamically measure distance in Power BI

Posts navigation

Previous page Page 1 … Page 11 Page 12

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

  • DAX Pareto Calculation
  • 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
Phil Seamark on DAX

Back to top
 

Loading Comments...