Tag: dax query tutorial

DAX Query In Power BI – Logical & Physical Query Plans

DAX Query In Power BI – Logical & Physical Query Plans

This tutorial will discuss about the two DAX Query Plans in Power BI. Query plans affect the DAX’s performance in generating valuable data. They also help in optimizing DAX codes that make your report more compelling. These are the two query plans that are generated by the formula engine: Logical Query Plan Physical Query Plan

Continue reading

DAX Query Structure In Power BI – Two Engines & DAX Studio

DAX Query Structure In Power BI - Two Engines & DAX Studio

This tutorial will be about the DAX query structure and the two engines inside DAX Studio. You’ll see the process behind how your DAX formulas produce results. You’ll also learn how each engine works in your calculation. There are two engines that are responsible for producing data: the formula engine and the VertiPaq storage engine.

Continue reading

DAX Tutorial: Context & The Calculation Engine

Understanding Context In DAX Calculations

In this DAX tutorial, we’ll discuss context and its significance to understanding how DAX calculation engine works in Power BI. The idea of contexts in Power BI isn’t easy and it’s often overlooked. However, we need to remember that we always need to include the concept of context into our minds, especially when dealing with

Continue reading