In this article, I’m going to describe a technique you may wish to consider to help speed up your Power BI reports. This specific technique is designed to help speed up reports that show common period comparisons such as: This year versus last year (as difference and/or percent) Delta, or percentage change over the previous … Continue reading Pivoting Data for Speed
For this blog, I want to share an interesting data modelling technique which you might consider when having performance problems with time intelligence calculations. This particular pattern works well on very large data-sets, especially for visuals that contain multiple measures and multiple periods. The idea is to create a Time Intelligence table which contains blocks … Continue reading Row-based Time Intelligence
Last time I was in Seattle, I was lucky enough to do a short video with the famous GuyInACube showing a useful technique I use when debugging DAX in Power BI. I hope you find it useful.
As an extension to my recent article on base conversions in DAX, I thought I’d show how these conversion calculations can be used to help you perform bitwise calculations in DAX. At present, there are no bitwise operators in DAX (I’m working on it!!), so calculations that need to perform AND, OR, XOR, NOT etc. … Continue reading DAX: Bitwise calculations