Data modelling and DAX
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
Did you know, in some cases, it is possible to add columns to your model to speed up the DAX used behind visuals to make them as much as 100 times faster? The PBIX helper file for this article can be downloaded here. I have come across this scenario a few times recently, so thought … Continue reading Speed up Power BI reports using columns
Introduction For this blog, I look at a method to take some text in the form of a horizontal sentence and use DAX to pivot the text into a vertical list of words. The PBIX file for this exercise can is available here. There is no current native function in DAX that can take a … Continue reading DAX : Pivot Text into a List of Words
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”