Tag: Advanced DAX

Table Visual In Power BI | Dynamic Subsetting

Table Visual In Power BI | Dynamic Subsetting

I want to spend some time today going through a question from Enterprise DNA member, Lucas about table visual in Power BI. It’s an interesting question in of itself, but I want to dissect it because it also touches on a bunch of other interesting topics, including disconnected tables, slicer harvesting, and some slicer visualization

Continue reading

Power BI Dynamic Grouping | Banding Using DAX

Power BI Dynamic Grouping | Banding Using DAX

I want to go over a Power BI dynamic grouping technique. I’ll show you how to dynamically showcase segments of your bands of information. This is a powerful technique to build upon your data model. You can watch the full video of this tutorial at the bottom of this blog. I have a really simple

Continue reading

Inventory Management Dashboard In Power BI

Inventory Management Dashboard In Power BI

In this tutorial, you’re going to learn the complex measures and DAX formula used to create an inventory management dashboard in Power BI. As a seller, you have to know how many products you need to re-order and stock and how much these will cost you. Use these DAX formula patterns to get those calculations

Continue reading

DAX Examples In Power BI – Advanced DAX Formulas

In this tutorial, I’ll show you some advanced formulas and DAX examples using different functions in Power BI. Some of the functions that you’ll encounter in the examples below are CALCULATE, FILTER, MAX, ALLSELECTED, and many more. But before you begin, make sure to optimize your measures. I always recommend using measure groups to make

Continue reading

Using DAX Table Functions In Power BI

I want to introduce you to a group of functions in Power BI called table functions. These functions include FILTER and ALL which we already used or mentioned in other topics. There is a whole range of other table functions which includes functions like VALUES, TOPN, and ADDCOLUMNS. However, we are not going to cover

Continue reading