Category: Data Modeling

Data Modeling Techniques To Organize DAX Measures

As you progress in Power BI, you will gradually be working with more DAX measures and calculations, and things can easily get cluttered. For today’s tutorial, I will share a few data modeling techniques on how to organize your DAX measures better for a more efficient workflow. You can watch the full video of this tutorial at

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

Power BI Parameters Via Query Editor

Creating And Using Parameter

In this tutorial, we’ll discuss how we can create and use Power BI Parameters which is a powerful feature of the Query Editor.  There are instances when we want to put additional filters on our data within the query editor. We can do that by utilizing the Manage Parameters option within the Home ribbon. For this

Continue reading

Data Modeling In Power BI Using Supporting Tables

Data Modelling Supporting Tables

When doing an analysis on our model, we might want to find an insight that’s unrelated to anything within our tables. That’s where the concept of using supporting tables for Power BI data modeling comes in. Supporting tables don’t have any relationship with our tables, but we can use them to support the visualizations in

Continue reading

Power BI Filtering Techniques For Tables

Power BI Filtering Techniques For Tables

In this blog, we’re going to learn about some essential Power BI filtering techniques for tables. We’ll discuss some simple techniques that we can utilize when we have massive tables on our query.  For example, when we need to extract information from a database or an ERP system, it could have 10 million rows within

Continue reading