Tag: AVERAGEX

Calculate Average Sales In Power BI

Calculate Average Sales In Power BI

In this tutorial, you’ll learn how to calculate average sales in Power BI. You’ll learn and understand the logic of some tools and iterating functions inside your visualizations. Formula patterns will be shown for you to utilize and practice to improve your data development skills. You can watch the full video of this tutorial at

Continue reading

DAX Power BI: What Is Row Context

In this blog, we are going to dive into row context in DAX Power BI. Another way to call it is the iterating calculation engine, but it is called row context from a more technical perspective. You may watch the full video of this tutorial at the bottom of this blog. DAX Power BI: Row

Continue reading

DAX Table Functions In Power BI

In this blog post, I’ll introduce you to DAX table functions. Table functions are simply DAX functions that return a table. Some of the most common table functions that you can encounter in Power BI are the FILTER, VALUES, and ALL functions. Using these table functions, you can create virtual tables inside Power BI. Physical

Continue reading

How To Use An Iterating Function In Power BI

This tutorial will teach you about different iterating functions and how to efficiently use them in your calculations. I often discuss how calculated columns are not required when making some calculations. This is because of iterators. Iterators or iterating functions can help you do a calculation without physically putting the results in the table. This

Continue reading

Using AVERAGEX In Power BI – A DAX Tutorial & Examples

Using The AVERAGEX Function - DAX Tutorial & Examples

AVERAGEX in Power BI is an incredibly versatile function. It’s not just for averaging values; it’s also great for trend analysis. You may watch the full video of this tutorial at the bottom of this blog. I discussed the use of AVERAGEX for trend analysis in the Enterprise DNA Learning Summit. A link to the

Continue reading