Data modelling and DAX
I always enjoy it when we get new DAX functions, especially so for the new set of WINDOW Functions recently added. As part of the April 2023 release of Power BI Desktop, we now have a RANK function and the ability to use a measure to control the order within the existing WINDOW function. The … Continue reading DAX Pareto Calculation
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
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
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
