Tag: dax query tutorial

Power BI Virtual Table | 5 Tips & Tricks For Debugging

_Power-BI-Virtual-Table-_-5-Tips-&-Tricks-For-Debugging

Power BI virtual table is my personal favorite DAX topic. They’re the key to unlocking the full power of DAX. Virtual tables are the only type of tables within Power BI that are fully dynamic, and there are problems that can only be solved by applying virtual table techniques within your measures. You may watch

Continue reading

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