Tag: DAX tutorial

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

Format Your DAX Formulas Easily With Our New DAX Clean Up Tool

We are working hard at Enterprise DNA to build a number of tools that can assist Power BI users in their development work.  Today we are excited to announce the release of our DAX Clean Up Tool  Why a new tool to format DAX formulas?  One of the biggest hurdles that any Power BI user faces when they start developing reports and dashboards is attempting to understand how DAX formulas and DAX code work.  We

Continue reading

Complete Refresh For Ultimate Beginners Guide To DAX

Recently, we’ve put the finishing touches on this course module and completed a comprehensive upgrade to the Ultimate Beginners Guide to DAX course module.  This is a completely free course available to anyone connected to Enterprise DNA.  To enroll in this course now, check out the link below.  Ultimate Beginners Guide to DAX There’s been quite a few changes to Power BI over the last 12 to 18

Continue reading

How To Use The CROSSJOIN Function – Power BI & DAX Tutorial

CROSSJOIN function

For this blog post, I want to demonstrate the CROSSJOIN function. I’m going to show an example of how I used it, and then explain when and where you can use it as well. CROSSJOIN is a really effective function that you can utilize inside of Power BI to essentially bind two tables of data

Continue reading

Find Top Customers Using RANKX In Power BI

Power BI is an amazing analytical engine! In this blog post, I’m going to show you how you can find your top customers – not just as static numbers, but through time and through any time period you could want. This is the power of DAX combined with the data model at its best. I

Continue reading