I’m going to talk about the solution I came up with for the 7th Problem of the Week. The problem required a dynamic report that uses multiple DAX calculation groups. You can watch the full video of this tutorial at the bottom of this blog. The Problem of the Week happens every 1st and 3rd
In this tutorial, you’ll learn about VertiPaq compression and storage in Power BI. These two features are essential things that you need to understand in order to maximize the use of Vertipaq in your report. They will help you gain a smoother and faster performance for your DAX codes. Column Storage Database For VertiPaq Compression
In this tutorial, you’ll learn about the VertiPaq Engine feature in Power BI which will help boost the performance of your DAX code. This post is an introduction to the Storage Engine and what it does with your DAX. DAX Query Structure For VertiPaq Engine Firstly, you need to understand the query structure that happens
Any Power BI user knows that the quality of the reports you make depends on what’s going on behind the scenes. DAX functions are among the pillars of a great Power BI report. This means that when your DAX functions are not optimized, your reports (and your entire experience as a Power BI user) are
I’m going to show you some great resources and tips around DAX cumulative total pattern. These are helpful in a number of scenarios you’ll be facing as you continue to work on reports and dashboard within Power BI. You may watch the full video of this tutorial at the bottom of this blog. You can
