Tag: Power BI Columns

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

Custom Columns In Power BI Vs. Conditional Columns

Custom and Conditional Columns

In this blog post, we’ll talk about the difference between Conditional and Custom Columns in Power BI. We’ll also show examples of when and how we can use them, including some of their alternatives.  Custom columns require a different formula language that we need to learn first. On the other hand, conditional columns are easy

Continue reading

Data Modelling In Power BI: Tips & Best Practices

Data Modelling In Power BI: Tips & Best Practices

In this tutorial, you’ll learn valuable tips and best practices for data modelling in Power BI. You can watch the full video of this tutorial at the bottom of this blog. This is one of the four pillars of Power BI report development and is a proven method to develop reports with ease. Honing in

Continue reading

Power BI Query Editor: Row & Column Transformations

Power BI Query Editor Row and Column Transformations

In this tutorial, we’ll discuss essential transformations within Power BI Query Editor that can be used to optimize your rows and columns. In developing an intuitive Power BI model, it’s best to simplify your rows and columns inside your table. Optimizing your table is essential in creating visualizations, so you can easily recognize your data.

Continue reading

The Importance Of Power BI Date Tables

The Importance Of Date Tables In Power BI Enterprise DNA

When working on Power BI date tables, it’s important to know the essential techniques so you can set things up as quickly as possible. In this tutorial, I’ll go over some important tips that can help you. The date tables are important in Power BI because you’ll need them to reference dates inside your model.

Continue reading