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: June 2020

DAX 1-Column Fusion Pt 2

DAX 1-Column Fusion Pt 2

Posted on June 24, 2020June 24, 20204 Comments on DAX 1-Column Fusion Pt 2

I received feedback on my recent blog post on single-column fusion asking about a curious syntax used in the solution. I promised I would do a deeper dive on why it works in my next blog, so here it is. This article is also a fun reminder/refresher on how iterator functions work in Power BI. … Continue reading DAX 1-Column Fusion Pt 2

DAX 1-Column Fusion

DAX 1-Column Fusion

Posted on June 12, 2020June 12, 20205 Comments on DAX 1-Column Fusion

One approach to optimise DAX queries is to focus on the number of Storage Engine (SE) calls generated by a query and look for ways to provide the same result using fewer SE calls. If a query takes 30 seconds to run and makes hundreds of SE calls, reducing the number of SE calls almost … Continue reading DAX 1-Column Fusion

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