Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • DAX Games
  • About Phil Seamark

A measure table called “Measures”

Posted on May 14, 2019July 8, 20199 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

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 10 Page 11

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
  • Relationships
  • SSMS
  • Time Intelligence
  • TMSL
  • TOM
  • Uncategorized
  • VS Code

Recent Posts

  • Power BI Storage Modes for Aggregations
  • Power BI Multiple Aggregations tables
  • Intro to Power BI Aggregations
  • DAX : Count number of last known state
  • Visualise your Power BI refresh – in real-time
Phil Seamark on DAX

Back to top
 

Loading Comments...