Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • DAX Games
  • About Phil Seamark

Category: Medium

Using Visual Studio Code with Power BI

Using Visual Studio Code with Power BI

Posted on July 9, 2020July 10, 202026 Comments on Using Visual Studio Code with Power BI

For this blog, I want to share a technique that allows you to use tools such as Visual Studio Code to connect and make changes to Power BI models. The technique not only allows you to browse the underlying model easily but also enhance and change such as adding/changing measures. Power BI data models are … Continue reading Using Visual Studio Code with Power BI

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, 20207 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

DAX KEEPFILTERS

DAX KEEPFILTERS

Posted on March 23, 2020March 23, 202010 Comments on DAX KEEPFILTERS

If you ever spend time looking at DAX generated by the Power BI Desktop Performance Analyser, you may notice a function called KEEPFILTERS appear from time to time. It’s not a function I find myself using often, so I thought I’d do a bit of digging to find out what it does and when it … Continue reading DAX KEEPFILTERS

Posts navigation

Page 1 Page 2 Page 3 Next page

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

  • 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
  • DAX : Count number of last known state
Phil Seamark on DAX

Back to top
 

Loading Comments...