Skip to content

Phil Seamark on DAX

Data modelling and DAX

  • Home
  • DAX Games
  • About Phil Seamark

Category: Data Modelling

DAX: Base conversions

DAX: Base conversions

Posted on October 2, 2019October 17, 20192 Comments on DAX: Base conversions

I was doing some work recently which required DAX calculations to convert values from a specific base to another, e.g. to convert a value in hexadecimal format to a base 10 representation (or decimal), or from base 10 to binary. Excel, like other languages has native functions to allow you to convert across base, such … Continue reading DAX: Base conversions

DAX Fusion

Posted on August 5, 2019August 5, 20199 Comments on DAX Fusion

Introduction: Around 2014, an enhancement was made to the DAX engine designed to help improve query speed. The enhancement, called DAX Fusion, looks to reduce the number of storage engine scans needed to satisfy queries, by combining similar scans where possible. This optimisation feature exists in Power BI, so can be used to help speed … Continue reading DAX Fusion

Tip to speed up Direct Query

Posted on July 18, 2019July 18, 20194 Comments on Tip to speed up Direct Query

This is not so much a DAX tip, rather something you might consider if you want to speed up the performance of any Direct Query (DQ) model you manage in Power BI or Analysis Services. The simple tip is to set relationships to use INNER JOIN rather than LEFT OUTER JOIN in the model. Once … Continue reading Tip to speed up Direct Query

Posts navigation

Previous page Page 1 … Page 6 Page 7

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...