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
Tag: Query Editor
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
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
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
This article will briefly talk about integrating scenarios into our models. We can do that by using the Power BI What If Parameter feature. We can add this parameter to our reports as slicers or reference them on DAX expressions. Integrating a What If Parameter into our reports enables us to create scenarios or predictive