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
Category: Query Editor
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.
In this blog, I’ll compare the existing customer allocation in depots or hubs to a newly-calculated allocation based on a selected distance. This kind of analysis allows businesses to deeply understand customer profitability. There are two similar datasets here which are the Customer data selection and Customer data current. I used these datasets to display
In this tutorial, you’ll learn about turning multiple calendar type layouts into a tabular format using Power Query in Power BI. You’ll learn how to transform multiple files instead of a single file from a folder. You may watch the full video of this tutorial at the bottom of this blog. This tutorial will also
In this tutorial, you’ll learn how to use Power Query for currency conversions in Power BI. You may watch the full video of this tutorial at the bottom of this blog. The method discussed in this blog will help you solve problems in your currency rates table using the last available rate. You’ll understand how