Tag: power bi dax functions

New DAX Function COLUMNSTATISTICS – Overview

This tutorial will walk you through COLUMNSTATISTICS() – a new DAX function, which is almost entirely undocumented. It has been added to Power BI in August 2021. You can watch the full video of this tutorial at the bottom of this blog. This function can be used to quickly create metadata on every table in

Continue reading

Using Text Functions In Power BI – DAX Tutorial

Using Text Functions In Power BI – DAX Tutorial

In today’s tutorial, I’m going to show how you can use path and text functions in Power BI to extract certain words from a given text string. You can watch the full video of this tutorial at the bottom of this blog. In this example, we have two rows of data sets and we want

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

DAX Calculations: Total Of Average Results

This is a very good demonstration of DAX calculations in Power BI. I will show you how you can calculate the total of a range of average results, utilizing the correct DAX formula combination. You may watch the full video of this tutorial at the bottom of this blog. This requires a reasonable understanding of

Continue reading

Predict Future Profitability Within Power BI DAX Functions

In this blog post, I will showcase some of the analytical work I enjoy doing the most… and that is working on future predictions using Power BI DAX functions. You may watch the full video of this tutorial at the bottom of this blog. I am always fascinated with trying to understand what could happen

Continue reading