Tag: Power BI Optimization

Create A Lookup Table From Subtotals: Optimization In Power BI

In this tutorial, we’ll go through a technique that will create a lookup table from subtotals using the query editor in Power BI. This is most useful when we’re getting data out of Microsoft Excel because most of its data will contain subtotals. We’ll be using some oil and gas statistics found online. Subtotals In

Continue reading

Row And Column Transformations In Power BI

I want to go over some of the best practices in optimizing your rows and columns inside the Query Editor. You can optimize your table so that when you create visualizations, you’ll be able to recognize your columns easily. One of the best ways to develop the most intuitive Power BI model is to simplify

Continue reading

Optimizing Your Power BI Formula Using Advanced DAX Functions

I’ll go over some interesting concepts that involve using several table functions to optimize your Power BI formula. I’m going to use an example from the Enterprise DNA Support Forum where one of the members asked if it’s possible to add a filter while using the SUMMARIZE function. This is quite common for scenarios when

Continue reading

Advanced Tips To Optimize Your Power BI Table

This tutorial showcases some advanced tips to optimize your Power BI table. I’ll show you how to break out your large table into multiple ones. This concern is quite common across legal database systems with huge flat files of information. Huge tables need to be broken down into simpler tables for easy information management. Most

Continue reading