Tag: Power BI DAX Formula

DAX MAXX Function In Power BI – Discover Last Date

I’m going to share a quick and efficient formula around the DAX MAXX function in Power BI. In this example calculation, I’ll show you how to find the last date something occurred using MAXX, which is an iterating function. I’ve seen a lot of people asking about this on the Enterprise DNA forum. A big

Continue reading

Inventory Dashboard Using Basic DAX In Power BI

Inventory Dashboard Using Basic DAX In Power BI

In this tutorial, I’m going to show you how to create a great inventory dashboard using some DAX formulas in Power BI. After properly setting up the data model, the next step is to write the DAX formulas and set up the visualizations for an inventory system in Power BI. This tutorial will show the

Continue reading

DAX Variables And Comments To Simplify Formulas

Simplify DAX Formulas Using Variables And Comments

In this tutorial, we’re going to discuss the easiest way to simplify DAX formulas using variables and comments in Power BI. DAX codes can become complex and hard to comprehend once they get more advanced. If we don’t optimize them, other Power BI users within the organization will have a difficult time understanding the data

Continue reading

Optimize Power BI Formulas Using Advanced DAX

I’ll go over some interesting concepts that involve using several table functions to optimize your Power BI formulas. 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

DAX Functions In Power BI: Using Iterators

Iterating DAX functions in Power BI or iterators are key concepts to learn and understand well. I made several tutorials around how and when to use these functions in DAX formulas. However, I’ve seen a few confusions with these functions in the Enterprise DNA Forum, so I thought it would be a good idea to discuss some of these issues encountered by Enterprise DNA members and show you the solutions.  As you learn more and go deeper into DAX formulas, you’ll find yourself

Continue reading