Tag: Power BI DAX Formula

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

Power BI DAX Formula Technique: Showcasing Growth Performance Effectively

Showcasing Growth Performance Effectively In Power BI - Advanced DAX

I want to share with you a Power BI DAX formula technique to show growth performance effectively.  In this tutorial, I’m going to demonstrate how it’s done, but there are so many different scenarios where you want to represent growth and this is just one example. The technique that I’m going to go through can

Continue reading