Tag: Optimization techniques

Power Query Optimization: Reducing Decimal Numbers

Power Query Optimization Reducing Decimal Numbers - Enterprise DNA

In this tutorial, you’ll learn a Power Query optimization technique to reduce RAM usage. Specifically, you’ll learn how to reduce the numbers stored after a decimal place. This is helpful if you’re dealing with columns stored in a decimal number format. In this example, you can see that the Net Price is consuming 11MB of

Continue reading

Storage Engine – Its Role In Optimizing DAX Queries in Power BI

In this tutorial, we’re going to take a look at the second engine inside analysis services — the storage engine. We discussed the top-level engine, the formula engine, in a past tutorial. When users understand how both these engines work, it’s easier to optimize and improve the performance of your DAX queries. The storage engine’s

Continue reading

Optimizing Queries For A Faster DAX Performance

Optimizing Queries For A Faster DAX Performance

This tutorial will talk about optimizing your queries in DAX Studio. You’ll also learn how to mitigate the presence of the CallBackDataID if ever they appear in your calculations. This will help improve DAX’s performance in generating accurate data. If you recall from previous blog posts, CallBackDataID appears when the storage engine asks help from

Continue reading

Iterators and Context Transitions In DAX Queries

Iterators and Context Transitions In DAX Queries

This tutorial will discuss context transition and nested Iterators. You’ll learn the importance of these entities and how they can be a good source for optimization. If you recall, context transition happens when a row context changes into an equivalent filter context. You need to be aware of what’s happening when a context transition occurs

Continue reading

DAX Queries Using Variables And Important Functions

DAX Queries Using Variables And Important Functions

This tutorial will discuss about variables, including the FILTER and CALCULATE functions. You’ll understand how these help boost the performance of your DAX queries and provide accurate results. Variables should be used as much as possible because they can easily locate codes for optimization. They prevent you from getting incorrect outputs and save you time

Continue reading