Category: Query Editor

Storage Engine In Power BI – VertiPaq Operators & Queries

Storage Engine In Power BI – VertiPaq Operators & Queries

This tutorial will discuss about the VertiPaq operators and storage engine queries in Power BI. You’ll learn how operators work behind the calculation and how the storage engine helps you to optimize your DAX codes’ performance. The VertiPaq operators and queries allow you to monitor the execution of each code so that you can improve

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

Customer Allocation: Current Vs Selection-based

Customer Allocation- Current Vs Selection-based

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

Continue reading

Calendar Layouts To Tabular Format Using Power Query

Tabular-Format-Using-Power-Query

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

Continue reading